﻿USE [master]
GO
/****** Object:  Database [DLM]    Script Date: 07/21/2012 18:59:22 ******/
CREATE DATABASE [DLM] ON  PRIMARY 
( NAME = N'DLM', FILENAME = N'D:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\DLM.mdf' , SIZE = 3072KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB )
 LOG ON 
( NAME = N'DLM_log', FILENAME = N'D:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\DLM_log.ldf' , SIZE = 1024KB , MAXSIZE = 2048GB , FILEGROWTH = 10%)
GO
IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled'))
begin
EXEC [DLM].[dbo].[sp_fulltext_database] @action = 'enable'
end
GO
ALTER DATABASE [DLM] SET ANSI_NULL_DEFAULT OFF
GO
ALTER DATABASE [DLM] SET ANSI_NULLS OFF
GO
ALTER DATABASE [DLM] SET ANSI_PADDING OFF
GO
ALTER DATABASE [DLM] SET ANSI_WARNINGS OFF
GO
ALTER DATABASE [DLM] SET ARITHABORT OFF
GO
ALTER DATABASE [DLM] SET AUTO_CLOSE OFF
GO
ALTER DATABASE [DLM] SET AUTO_CREATE_STATISTICS ON
GO
ALTER DATABASE [DLM] SET AUTO_SHRINK OFF
GO
ALTER DATABASE [DLM] SET AUTO_UPDATE_STATISTICS ON
GO
ALTER DATABASE [DLM] SET CURSOR_CLOSE_ON_COMMIT OFF
GO
ALTER DATABASE [DLM] SET CURSOR_DEFAULT  GLOBAL
GO
ALTER DATABASE [DLM] SET CONCAT_NULL_YIELDS_NULL OFF
GO
ALTER DATABASE [DLM] SET NUMERIC_ROUNDABORT OFF
GO
ALTER DATABASE [DLM] SET QUOTED_IDENTIFIER OFF
GO
ALTER DATABASE [DLM] SET RECURSIVE_TRIGGERS OFF
GO
ALTER DATABASE [DLM] SET  DISABLE_BROKER
GO
ALTER DATABASE [DLM] SET AUTO_UPDATE_STATISTICS_ASYNC OFF
GO
ALTER DATABASE [DLM] SET DATE_CORRELATION_OPTIMIZATION OFF
GO
ALTER DATABASE [DLM] SET TRUSTWORTHY OFF
GO
ALTER DATABASE [DLM] SET ALLOW_SNAPSHOT_ISOLATION OFF
GO
ALTER DATABASE [DLM] SET PARAMETERIZATION SIMPLE
GO
ALTER DATABASE [DLM] SET READ_COMMITTED_SNAPSHOT OFF
GO
ALTER DATABASE [DLM] SET  READ_WRITE
GO
ALTER DATABASE [DLM] SET RECOVERY FULL
GO
ALTER DATABASE [DLM] SET  MULTI_USER
GO
ALTER DATABASE [DLM] SET PAGE_VERIFY CHECKSUM
GO
ALTER DATABASE [DLM] SET DB_CHAINING OFF
GO
EXEC sys.sp_db_vardecimal_storage_format N'DLM', N'ON'
GO
USE [DLM]
GO
/****** Object:  Table [dbo].[Log]    Script Date: 07/21/2012 18:59:24 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Log](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[Date] [datetime] NOT NULL,
	[Thread] [varchar](255) NOT NULL,
	[Level] [varchar](50) NOT NULL,
	[Logger] [varchar](255) NOT NULL,
	[Message] [varchar](4000) NOT NULL,
	[Exception] [varchar](2000) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
SET IDENTITY_INSERT [dbo].[Log] ON
INSERT [dbo].[Log] ([Id], [Date], [Thread], [Level], [Logger], [Message], [Exception]) VALUES (1, CAST(0x0000A08F011B358A AS DateTime), N'5', N'INFO', N'DLMLogger', N'Application start!', N'')
INSERT [dbo].[Log] ([Id], [Date], [Thread], [Level], [Logger], [Message], [Exception]) VALUES (2, CAST(0x0000A08F011D6B30 AS DateTime), N'5', N'INFO', N'DLMLogger', N'Application start!', N'')
INSERT [dbo].[Log] ([Id], [Date], [Thread], [Level], [Logger], [Message], [Exception]) VALUES (3, CAST(0x0000A08F011F9E2E AS DateTime), N'5', N'INFO', N'DLMLogger', N'Application start!', N'')
INSERT [dbo].[Log] ([Id], [Date], [Thread], [Level], [Logger], [Message], [Exception]) VALUES (4, CAST(0x0000A08F012031DC AS DateTime), N'5', N'ERROR', N'DLMLogger', N'Entity property Password is invalidate.Error message is 密码长度最大为15位', N'System.Data.Entity.Validation.DbEntityValidationException: Validation failed for one or more entities. See ''EntityValidationErrors'' property for more details.
   at System.Data.Entity.Internal.InternalContext.SaveChanges()
   at System.Data.Entity.Internal.LazyInternalContext.SaveChanges()
   at System.Data.Entity.DbContext.SaveChanges()
   at DLM.Data.EF.CodeFirst.UnitOfWork.Commit() in D:\GitRepository\dlm\DLM.SNS\DLM.Data.EF.CodeFirst\UnitOfWork.cs:line 46
   at DLM.Data.EF.CodeFirst.Repositories.Repository`2.Add(T entity) in D:\GitRepository\dlm\DLM.SNS\DLM.Data.EF.CodeFirst\Repositories\Repository.cs:line 92')
INSERT [dbo].[Log] ([Id], [Date], [Thread], [Level], [Logger], [Message], [Exception]) VALUES (5, CAST(0x0000A08F0120B3F9 AS DateTime), N'5', N'INFO', N'DLMLogger', N'Application start!', N'')
INSERT [dbo].[Log] ([Id], [Date], [Thread], [Level], [Logger], [Message], [Exception]) VALUES (6, CAST(0x0000A08F0126B75D AS DateTime), N'14', N'INFO', N'DLMLogger', N'Application start!', N'')
INSERT [dbo].[Log] ([Id], [Date], [Thread], [Level], [Logger], [Message], [Exception]) VALUES (7, CAST(0x0000A08F01371ADB AS DateTime), N'26', N'INFO', N'DLMLogger', N'Application start!', N'')
INSERT [dbo].[Log] ([Id], [Date], [Thread], [Level], [Logger], [Message], [Exception]) VALUES (8, CAST(0x0000A08F013A2DBF AS DateTime), N'11', N'ERROR', N'DLMLogger', N'Entity property Photo is invalidate.Error message is 用户头像必须上传！', N'System.Data.Entity.Validation.DbEntityValidationException: Validation failed for one or more entities. See ''EntityValidationErrors'' property for more details.
   at System.Data.Entity.Internal.InternalContext.SaveChanges()
   at System.Data.Entity.Internal.LazyInternalContext.SaveChanges()
   at System.Data.Entity.DbContext.SaveChanges()
   at DLM.Data.EF.CodeFirst.UnitOfWork.Commit() in D:\GitRepository\dlm\DLM.SNS\DLM.Data.EF.CodeFirst\UnitOfWork.cs:line 46
   at DLM.Data.EF.CodeFirst.Repositories.Repository`2.Save(T entity) in D:\GitRepository\dlm\DLM.SNS\DLM.Data.EF.CodeFirst\Repositories\Repository.cs:line 61')
INSERT [dbo].[Log] ([Id], [Date], [Thread], [Level], [Logger], [Message], [Exception]) VALUES (9, CAST(0x0000A08F013A422D AS DateTime), N'28', N'ERROR', N'DLMLogger', N'Entity property Photo is invalidate.Error message is 用户头像必须上传！', N'System.Data.Entity.Validation.DbEntityValidationException: Validation failed for one or more entities. See ''EntityValidationErrors'' property for more details.
   at System.Data.Entity.Internal.InternalContext.SaveChanges()
   at System.Data.Entity.Internal.LazyInternalContext.SaveChanges()
   at System.Data.Entity.DbContext.SaveChanges()
   at DLM.Data.EF.CodeFirst.UnitOfWork.Commit() in D:\GitRepository\dlm\DLM.SNS\DLM.Data.EF.CodeFirst\UnitOfWork.cs:line 46
   at DLM.Data.EF.CodeFirst.Repositories.Repository`2.Save(T entity) in D:\GitRepository\dlm\DLM.SNS\DLM.Data.EF.CodeFirst\Repositories\Repository.cs:line 61')
INSERT [dbo].[Log] ([Id], [Date], [Thread], [Level], [Logger], [Message], [Exception]) VALUES (10, CAST(0x0000A08F013C4A10 AS DateTime), N'28', N'INFO', N'DLMLogger', N'Application start!', N'')
INSERT [dbo].[Log] ([Id], [Date], [Thread], [Level], [Logger], [Message], [Exception]) VALUES (11, CAST(0x0000A08F0143A23E AS DateTime), N'19', N'INFO', N'DLMLogger', N'Application start!', N'')
INSERT [dbo].[Log] ([Id], [Date], [Thread], [Level], [Logger], [Message], [Exception]) VALUES (12, CAST(0x0000A08F014A18E5 AS DateTime), N'36', N'INFO', N'DLMLogger', N'Application start!', N'')
INSERT [dbo].[Log] ([Id], [Date], [Thread], [Level], [Logger], [Message], [Exception]) VALUES (13, CAST(0x0000A08F015A20F7 AS DateTime), N'32', N'INFO', N'DLMLogger', N'Application start!', N'')
INSERT [dbo].[Log] ([Id], [Date], [Thread], [Level], [Logger], [Message], [Exception]) VALUES (14, CAST(0x0000A08F015AE52A AS DateTime), N'34', N'INFO', N'DLMLogger', N'Application start!', N'')
INSERT [dbo].[Log] ([Id], [Date], [Thread], [Level], [Logger], [Message], [Exception]) VALUES (15, CAST(0x0000A08F01674849 AS DateTime), N'12', N'INFO', N'DLMLogger', N'Application start!', N'')
INSERT [dbo].[Log] ([Id], [Date], [Thread], [Level], [Logger], [Message], [Exception]) VALUES (16, CAST(0x0000A08F016BDA0C AS DateTime), N'25', N'INFO', N'DLMLogger', N'Application start!', N'')
INSERT [dbo].[Log] ([Id], [Date], [Thread], [Level], [Logger], [Message], [Exception]) VALUES (17, CAST(0x0000A08F0170AEA3 AS DateTime), N'5', N'INFO', N'DLMLogger', N'Application start!', N'')
INSERT [dbo].[Log] ([Id], [Date], [Thread], [Level], [Logger], [Message], [Exception]) VALUES (18, CAST(0x0000A08F0171F837 AS DateTime), N'8', N'INFO', N'DLMLogger', N'Application start!', N'')
INSERT [dbo].[Log] ([Id], [Date], [Thread], [Level], [Logger], [Message], [Exception]) VALUES (19, CAST(0x0000A08F01765EEB AS DateTime), N'5', N'INFO', N'DLMLogger', N'Application start!', N'')
INSERT [dbo].[Log] ([Id], [Date], [Thread], [Level], [Logger], [Message], [Exception]) VALUES (22, CAST(0x0000A0900106A8CB AS DateTime), N'17', N'INFO', N'DLMLogger', N'Application start!', N'')
INSERT [dbo].[Log] ([Id], [Date], [Thread], [Level], [Logger], [Message], [Exception]) VALUES (23, CAST(0x0000A09001078757 AS DateTime), N'18', N'INFO', N'DLMLogger', N'Application start!', N'')
INSERT [dbo].[Log] ([Id], [Date], [Thread], [Level], [Logger], [Message], [Exception]) VALUES (24, CAST(0x0000A090010DD8D6 AS DateTime), N'24', N'INFO', N'DLMLogger', N'Application start!', N'')
INSERT [dbo].[Log] ([Id], [Date], [Thread], [Level], [Logger], [Message], [Exception]) VALUES (25, CAST(0x0000A090010E68B9 AS DateTime), N'26', N'INFO', N'DLMLogger', N'Application start!', N'')
INSERT [dbo].[Log] ([Id], [Date], [Thread], [Level], [Logger], [Message], [Exception]) VALUES (26, CAST(0x0000A090010FBD68 AS DateTime), N'5', N'INFO', N'DLMLogger', N'Application start!', N'')
INSERT [dbo].[Log] ([Id], [Date], [Thread], [Level], [Logger], [Message], [Exception]) VALUES (27, CAST(0x0000A09001119276 AS DateTime), N'22', N'INFO', N'DLMLogger', N'Application start!', N'')
INSERT [dbo].[Log] ([Id], [Date], [Thread], [Level], [Logger], [Message], [Exception]) VALUES (28, CAST(0x0000A09001135E9E AS DateTime), N'18', N'INFO', N'DLMLogger', N'Application start!', N'')
INSERT [dbo].[Log] ([Id], [Date], [Thread], [Level], [Logger], [Message], [Exception]) VALUES (29, CAST(0x0000A09001140A84 AS DateTime), N'21', N'INFO', N'DLMLogger', N'Application start!', N'')
INSERT [dbo].[Log] ([Id], [Date], [Thread], [Level], [Logger], [Message], [Exception]) VALUES (30, CAST(0x0000A09101566A16 AS DateTime), N'5', N'INFO', N'DLMLogger', N'Application start!', N'')
INSERT [dbo].[Log] ([Id], [Date], [Thread], [Level], [Logger], [Message], [Exception]) VALUES (31, CAST(0x0000A09101592780 AS DateTime), N'21', N'INFO', N'DLMLogger', N'Application start!', N'')
INSERT [dbo].[Log] ([Id], [Date], [Thread], [Level], [Logger], [Message], [Exception]) VALUES (32, CAST(0x0000A0910164F3A3 AS DateTime), N'63', N'INFO', N'DLMLogger', N'Application start!', N'')
INSERT [dbo].[Log] ([Id], [Date], [Thread], [Level], [Logger], [Message], [Exception]) VALUES (33, CAST(0x0000A091016676C3 AS DateTime), N'64', N'INFO', N'DLMLogger', N'Application start!', N'')
INSERT [dbo].[Log] ([Id], [Date], [Thread], [Level], [Logger], [Message], [Exception]) VALUES (34, CAST(0x0000A0910166D21B AS DateTime), N'58', N'INFO', N'DLMLogger', N'Application start!', N'')
INSERT [dbo].[Log] ([Id], [Date], [Thread], [Level], [Logger], [Message], [Exception]) VALUES (35, CAST(0x0000A0910167F8D7 AS DateTime), N'53', N'INFO', N'DLMLogger', N'Application start!', N'')
INSERT [dbo].[Log] ([Id], [Date], [Thread], [Level], [Logger], [Message], [Exception]) VALUES (36, CAST(0x0000A09101681700 AS DateTime), N'58', N'INFO', N'DLMLogger', N'Application start!', N'')
INSERT [dbo].[Log] ([Id], [Date], [Thread], [Level], [Logger], [Message], [Exception]) VALUES (37, CAST(0x0000A09101683A61 AS DateTime), N'58', N'INFO', N'DLMLogger', N'Application start!', N'')
INSERT [dbo].[Log] ([Id], [Date], [Thread], [Level], [Logger], [Message], [Exception]) VALUES (38, CAST(0x0000A0910168AFCA AS DateTime), N'55', N'INFO', N'DLMLogger', N'Application start!', N'')
INSERT [dbo].[Log] ([Id], [Date], [Thread], [Level], [Logger], [Message], [Exception]) VALUES (39, CAST(0x0000A09101692213 AS DateTime), N'51', N'INFO', N'DLMLogger', N'Application start!', N'')
INSERT [dbo].[Log] ([Id], [Date], [Thread], [Level], [Logger], [Message], [Exception]) VALUES (40, CAST(0x0000A09101696DC5 AS DateTime), N'51', N'INFO', N'DLMLogger', N'Application start!', N'')
INSERT [dbo].[Log] ([Id], [Date], [Thread], [Level], [Logger], [Message], [Exception]) VALUES (41, CAST(0x0000A0910169C64D AS DateTime), N'51', N'INFO', N'DLMLogger', N'Application start!', N'')
INSERT [dbo].[Log] ([Id], [Date], [Thread], [Level], [Logger], [Message], [Exception]) VALUES (42, CAST(0x0000A091016A10F9 AS DateTime), N'52', N'INFO', N'DLMLogger', N'Application start!', N'')
INSERT [dbo].[Log] ([Id], [Date], [Thread], [Level], [Logger], [Message], [Exception]) VALUES (43, CAST(0x0000A091016A579D AS DateTime), N'47', N'INFO', N'DLMLogger', N'Application start!', N'')
INSERT [dbo].[Log] ([Id], [Date], [Thread], [Level], [Logger], [Message], [Exception]) VALUES (44, CAST(0x0000A09101871E3C AS DateTime), N'5', N'INFO', N'DLMLogger', N'Application start!', N'')
INSERT [dbo].[Log] ([Id], [Date], [Thread], [Level], [Logger], [Message], [Exception]) VALUES (45, CAST(0x0000A0910189D351 AS DateTime), N'27', N'INFO', N'DLMLogger', N'Application start!', N'')
INSERT [dbo].[Log] ([Id], [Date], [Thread], [Level], [Logger], [Message], [Exception]) VALUES (46, CAST(0x0000A092000010F8 AS DateTime), N'31', N'INFO', N'DLMLogger', N'Application start!', N'')
INSERT [dbo].[Log] ([Id], [Date], [Thread], [Level], [Logger], [Message], [Exception]) VALUES (47, CAST(0x0000A0920004C8D4 AS DateTime), N'30', N'INFO', N'DLMLogger', N'Application start!', N'')
INSERT [dbo].[Log] ([Id], [Date], [Thread], [Level], [Logger], [Message], [Exception]) VALUES (48, CAST(0x0000A09200D3839A AS DateTime), N'5', N'INFO', N'DLMLogger', N'Application start!', N'')
INSERT [dbo].[Log] ([Id], [Date], [Thread], [Level], [Logger], [Message], [Exception]) VALUES (49, CAST(0x0000A09200D42AD5 AS DateTime), N'5', N'ERROR', N'DLMLogger', N'Entity property Photo is invalidate.Error message is 用户头像必须上传！', N'System.Data.Entity.Validation.DbEntityValidationException: Validation failed for one or more entities. See ''EntityValidationErrors'' property for more details.
   at System.Data.Entity.Internal.InternalContext.SaveChanges()
   at System.Data.Entity.Internal.LazyInternalContext.SaveChanges()
   at System.Data.Entity.DbContext.SaveChanges()
   at DLM.Data.EF.CodeFirst.UnitOfWork.Commit() in D:\GitRepository\dlm\DLM.SNS\DLM.Data.EF.CodeFirst\UnitOfWork.cs:line 46
   at DLM.Data.EF.CodeFirst.Repositories.Repository`2.Add(T entity) in D:\GitRepository\dlm\DLM.SNS\DLM.Data.EF.CodeFirst\Repositories\Repository.cs:line 92')
INSERT [dbo].[Log] ([Id], [Date], [Thread], [Level], [Logger], [Message], [Exception]) VALUES (50, CAST(0x0000A09200D4978F AS DateTime), N'13', N'ERROR', N'DLMLogger', N'Entity property Photo is invalidate.Error message is 用户头像必须上传！', N'System.Data.Entity.Validation.DbEntityValidationException: Validation failed for one or more entities. See ''EntityValidationErrors'' property for more details.
   at System.Data.Entity.Internal.InternalContext.SaveChanges()
   at System.Data.Entity.Internal.LazyInternalContext.SaveChanges()
   at System.Data.Entity.DbContext.SaveChanges()
   at DLM.Data.EF.CodeFirst.UnitOfWork.Commit() in D:\GitRepository\dlm\DLM.SNS\DLM.Data.EF.CodeFirst\UnitOfWork.cs:line 46
   at DLM.Data.EF.CodeFirst.Repositories.Repository`2.Add(T entity) in D:\GitRepository\dlm\DLM.SNS\DLM.Data.EF.CodeFirst\Repositories\Repository.cs:line 92')
INSERT [dbo].[Log] ([Id], [Date], [Thread], [Level], [Logger], [Message], [Exception]) VALUES (51, CAST(0x0000A09200D4E1DB AS DateTime), N'12', N'INFO', N'DLMLogger', N'Application start!', N'')
INSERT [dbo].[Log] ([Id], [Date], [Thread], [Level], [Logger], [Message], [Exception]) VALUES (52, CAST(0x0000A09200DBF5EE AS DateTime), N'22', N'INFO', N'DLMLogger', N'Application start!', N'')
INSERT [dbo].[Log] ([Id], [Date], [Thread], [Level], [Logger], [Message], [Exception]) VALUES (53, CAST(0x0000A09200FC8092 AS DateTime), N'10', N'INFO', N'DLMLogger', N'Application start!', N'')
INSERT [dbo].[Log] ([Id], [Date], [Thread], [Level], [Logger], [Message], [Exception]) VALUES (54, CAST(0x0000A092011292AD AS DateTime), N'6', N'INFO', N'DLMLogger', N'Application start!', N'')
INSERT [dbo].[Log] ([Id], [Date], [Thread], [Level], [Logger], [Message], [Exception]) VALUES (55, CAST(0x0000A09201180CC7 AS DateTime), N'21', N'INFO', N'DLMLogger', N'Application start!', N'')
INSERT [dbo].[Log] ([Id], [Date], [Thread], [Level], [Logger], [Message], [Exception]) VALUES (56, CAST(0x0000A09201226AF7 AS DateTime), N'29', N'INFO', N'DLMLogger', N'Application start!', N'')
INSERT [dbo].[Log] ([Id], [Date], [Thread], [Level], [Logger], [Message], [Exception]) VALUES (58, CAST(0x0000A09300A333C2 AS DateTime), N'5', N'INFO', N'DLMLogger', N'Application start!', N'')
INSERT [dbo].[Log] ([Id], [Date], [Thread], [Level], [Logger], [Message], [Exception]) VALUES (59, CAST(0x0000A09300BCC51E AS DateTime), N'25', N'INFO', N'DLMLogger', N'Application start!', N'')
INSERT [dbo].[Log] ([Id], [Date], [Thread], [Level], [Logger], [Message], [Exception]) VALUES (60, CAST(0x0000A09300BE241A AS DateTime), N'23', N'INFO', N'DLMLogger', N'Application start!', N'')
INSERT [dbo].[Log] ([Id], [Date], [Thread], [Level], [Logger], [Message], [Exception]) VALUES (61, CAST(0x0000A09300BF8C2A AS DateTime), N'28', N'INFO', N'DLMLogger', N'Application start!', N'')
INSERT [dbo].[Log] ([Id], [Date], [Thread], [Level], [Logger], [Message], [Exception]) VALUES (62, CAST(0x0000A09300ED15E8 AS DateTime), N'42', N'INFO', N'DLMLogger', N'Application start!', N'')
INSERT [dbo].[Log] ([Id], [Date], [Thread], [Level], [Logger], [Message], [Exception]) VALUES (63, CAST(0x0000A09300F51413 AS DateTime), N'28', N'INFO', N'DLMLogger', N'Application start!', N'')
INSERT [dbo].[Log] ([Id], [Date], [Thread], [Level], [Logger], [Message], [Exception]) VALUES (64, CAST(0x0000A09300F9FC3C AS DateTime), N'10', N'INFO', N'DLMLogger', N'Application start!', N'')
INSERT [dbo].[Log] ([Id], [Date], [Thread], [Level], [Logger], [Message], [Exception]) VALUES (65, CAST(0x0000A093010939E0 AS DateTime), N'6', N'INFO', N'DLMLogger', N'Application start!', N'')
INSERT [dbo].[Log] ([Id], [Date], [Thread], [Level], [Logger], [Message], [Exception]) VALUES (66, CAST(0x0000A09301143BB3 AS DateTime), N'22', N'INFO', N'DLMLogger', N'Application start!', N'')
INSERT [dbo].[Log] ([Id], [Date], [Thread], [Level], [Logger], [Message], [Exception]) VALUES (67, CAST(0x0000A09301193A70 AS DateTime), N'13', N'INFO', N'DLMLogger', N'Application start!', N'')
INSERT [dbo].[Log] ([Id], [Date], [Thread], [Level], [Logger], [Message], [Exception]) VALUES (68, CAST(0x0000A093012E5A94 AS DateTime), N'5', N'INFO', N'DLMLogger', N'Application start!', N'')
INSERT [dbo].[Log] ([Id], [Date], [Thread], [Level], [Logger], [Message], [Exception]) VALUES (69, CAST(0x0000A09400A47B84 AS DateTime), N'5', N'INFO', N'DLMLogger', N'Application start!', N'')
INSERT [dbo].[Log] ([Id], [Date], [Thread], [Level], [Logger], [Message], [Exception]) VALUES (70, CAST(0x0000A09400AD83A6 AS DateTime), N'15', N'INFO', N'DLMLogger', N'Application start!', N'')
INSERT [dbo].[Log] ([Id], [Date], [Thread], [Level], [Logger], [Message], [Exception]) VALUES (71, CAST(0x0000A09400B37CC2 AS DateTime), N'14', N'INFO', N'DLMLogger', N'Application start!', N'')
INSERT [dbo].[Log] ([Id], [Date], [Thread], [Level], [Logger], [Message], [Exception]) VALUES (72, CAST(0x0000A09400CA81CF AS DateTime), N'39', N'INFO', N'DLMLogger', N'Application start!', N'')
INSERT [dbo].[Log] ([Id], [Date], [Thread], [Level], [Logger], [Message], [Exception]) VALUES (73, CAST(0x0000A09400CC6F41 AS DateTime), N'40', N'INFO', N'DLMLogger', N'Application start!', N'')
INSERT [dbo].[Log] ([Id], [Date], [Thread], [Level], [Logger], [Message], [Exception]) VALUES (74, CAST(0x0000A09400CEBEB5 AS DateTime), N'26', N'INFO', N'DLMLogger', N'Application start!', N'')
INSERT [dbo].[Log] ([Id], [Date], [Thread], [Level], [Logger], [Message], [Exception]) VALUES (75, CAST(0x0000A09400DDCE2E AS DateTime), N'26', N'INFO', N'DLMLogger', N'Application start!', N'')
INSERT [dbo].[Log] ([Id], [Date], [Thread], [Level], [Logger], [Message], [Exception]) VALUES (76, CAST(0x0000A09400E2D7B9 AS DateTime), N'9', N'INFO', N'DLMLogger', N'Application start!', N'')
INSERT [dbo].[Log] ([Id], [Date], [Thread], [Level], [Logger], [Message], [Exception]) VALUES (77, CAST(0x0000A09400E31ADC AS DateTime), N'38', N'INFO', N'DLMLogger', N'Value cannot be null.
Parameter name: items', N'')
INSERT [dbo].[Log] ([Id], [Date], [Thread], [Level], [Logger], [Message], [Exception]) VALUES (78, CAST(0x0000A09400E39F3A AS DateTime), N'38', N'INFO', N'DLMLogger', N'"class" is a reserved word and cannot be used in implicit expressions.  An explicit expression ("@()") must be used.
', N'')
INSERT [dbo].[Log] ([Id], [Date], [Thread], [Level], [Logger], [Message], [Exception]) VALUES (79, CAST(0x0000A09400E88F7A AS DateTime), N'27', N'INFO', N'DLMLogger', N'Application start!', N'')
INSERT [dbo].[Log] ([Id], [Date], [Thread], [Level], [Logger], [Message], [Exception]) VALUES (80, CAST(0x0000A09400F73B17 AS DateTime), N'25', N'INFO', N'DLMLogger', N'Application start!', N'')
INSERT [dbo].[Log] ([Id], [Date], [Thread], [Level], [Logger], [Message], [Exception]) VALUES (81, CAST(0x0000A09400FF0E17 AS DateTime), N'10', N'INFO', N'DLMLogger', N'Application start!', N'')
INSERT [dbo].[Log] ([Id], [Date], [Thread], [Level], [Logger], [Message], [Exception]) VALUES (82, CAST(0x0000A09401003A28 AS DateTime), N'10', N'INFO', N'DLMLogger', N'Application start!', N'')
INSERT [dbo].[Log] ([Id], [Date], [Thread], [Level], [Logger], [Message], [Exception]) VALUES (83, CAST(0x0000A0940105B417 AS DateTime), N'15', N'INFO', N'DLMLogger', N'Application start!', N'')
INSERT [dbo].[Log] ([Id], [Date], [Thread], [Level], [Logger], [Message], [Exception]) VALUES (84, CAST(0x0000A09500A01228 AS DateTime), N'5', N'INFO', N'DLMLogger', N'Application start!', N'')
INSERT [dbo].[Log] ([Id], [Date], [Thread], [Level], [Logger], [Message], [Exception]) VALUES (85, CAST(0x0000A09500A4DE0E AS DateTime), N'23', N'INFO', N'DLMLogger', N'Application start!', N'')
INSERT [dbo].[Log] ([Id], [Date], [Thread], [Level], [Logger], [Message], [Exception]) VALUES (86, CAST(0x0000A09500A58C6B AS DateTime), N'23', N'INFO', N'DLMLogger', N'Application start!', N'')
INSERT [dbo].[Log] ([Id], [Date], [Thread], [Level], [Logger], [Message], [Exception]) VALUES (87, CAST(0x0000A09500AB3BF8 AS DateTime), N'12', N'INFO', N'DLMLogger', N'Application start!', N'')
INSERT [dbo].[Log] ([Id], [Date], [Thread], [Level], [Logger], [Message], [Exception]) VALUES (88, CAST(0x0000A09500ABBA13 AS DateTime), N'12', N'INFO', N'DLMLogger', N'Application start!', N'')
INSERT [dbo].[Log] ([Id], [Date], [Thread], [Level], [Logger], [Message], [Exception]) VALUES (89, CAST(0x0000A09500AFDDD6 AS DateTime), N'24', N'INFO', N'DLMLogger', N'Application start!', N'')
INSERT [dbo].[Log] ([Id], [Date], [Thread], [Level], [Logger], [Message], [Exception]) VALUES (90, CAST(0x0000A09500B10748 AS DateTime), N'25', N'INFO', N'DLMLogger', N'Application start!', N'')
INSERT [dbo].[Log] ([Id], [Date], [Thread], [Level], [Logger], [Message], [Exception]) VALUES (91, CAST(0x0000A09500B1A1D0 AS DateTime), N'23', N'INFO', N'DLMLogger', N'Cannot redirect after HTTP headers have been sent.', N'')
INSERT [dbo].[Log] ([Id], [Date], [Thread], [Level], [Logger], [Message], [Exception]) VALUES (92, CAST(0x0000A09500B2FF75 AS DateTime), N'27', N'INFO', N'DLMLogger', N'Application start!', N'')
INSERT [dbo].[Log] ([Id], [Date], [Thread], [Level], [Logger], [Message], [Exception]) VALUES (93, CAST(0x0000A09500B3504E AS DateTime), N'27', N'INFO', N'DLMLogger', N'Cannot redirect after HTTP headers have been sent.', N'')
INSERT [dbo].[Log] ([Id], [Date], [Thread], [Level], [Logger], [Message], [Exception]) VALUES (94, CAST(0x0000A09500B3CA32 AS DateTime), N'21', N'INFO', N'DLMLogger', N'Cannot redirect after HTTP headers have been sent.', N'')
INSERT [dbo].[Log] ([Id], [Date], [Thread], [Level], [Logger], [Message], [Exception]) VALUES (95, CAST(0x0000A09500EC88E4 AS DateTime), N'14', N'INFO', N'DLMLogger', N'Application start!', N'')
INSERT [dbo].[Log] ([Id], [Date], [Thread], [Level], [Logger], [Message], [Exception]) VALUES (96, CAST(0x0000A09500ECD4A0 AS DateTime), N'14', N'INFO', N'DLMLogger', N'Application start!', N'')
SET IDENTITY_INSERT [dbo].[Log] OFF
/****** Object:  Table [dbo].[Remark]    Script Date: 07/21/2012 18:59:24 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Remark](
	[RemarkID] [int] IDENTITY(1,1) NOT NULL,
	[PartyID] [int] NOT NULL,
	[UserID] [int] NOT NULL,
	[Content] [nvarchar](100) NULL,
	[Rate] [int] NOT NULL,
	[CreateDate] [datetime] NOT NULL,
 CONSTRAINT [PK_Remark] PRIMARY KEY CLUSTERED 
(
	[RemarkID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET IDENTITY_INSERT [dbo].[Remark] ON
INSERT [dbo].[Remark] ([RemarkID], [PartyID], [UserID], [Content], [Rate], [CreateDate]) VALUES (1, 1, 2, N'这次的活动还可以吧', 8, CAST(0x0000A09101884791 AS DateTime))
INSERT [dbo].[Remark] ([RemarkID], [PartyID], [UserID], [Content], [Rate], [CreateDate]) VALUES (2, 1, 2, N'test', 10, CAST(0x0000A0910188B39C AS DateTime))
INSERT [dbo].[Remark] ([RemarkID], [PartyID], [UserID], [Content], [Rate], [CreateDate]) VALUES (3, 1, 2, N'dfdfdf', 7, CAST(0x0000A09101895C49 AS DateTime))
INSERT [dbo].[Remark] ([RemarkID], [PartyID], [UserID], [Content], [Rate], [CreateDate]) VALUES (4, 1, 2, N'dfgfgfg', 7, CAST(0x0000A091018A45A4 AS DateTime))
INSERT [dbo].[Remark] ([RemarkID], [PartyID], [UserID], [Content], [Rate], [CreateDate]) VALUES (5, 1, 2, N'fgfgfg', 5, CAST(0x0000A091018ABFEC AS DateTime))
INSERT [dbo].[Remark] ([RemarkID], [PartyID], [UserID], [Content], [Rate], [CreateDate]) VALUES (6, 1, 2, N'fgfgfg', 8, CAST(0x0000A092000060FB AS DateTime))
INSERT [dbo].[Remark] ([RemarkID], [PartyID], [UserID], [Content], [Rate], [CreateDate]) VALUES (7, 1, 2, N'dfdfdf', 9, CAST(0x0000A0920000A83B AS DateTime))
INSERT [dbo].[Remark] ([RemarkID], [PartyID], [UserID], [Content], [Rate], [CreateDate]) VALUES (8, 1, 1, N'dfdfd', 7, CAST(0x0000A09200DE92DC AS DateTime))
INSERT [dbo].[Remark] ([RemarkID], [PartyID], [UserID], [Content], [Rate], [CreateDate]) VALUES (9, 3, 2, N'dfdfdfdf', 9, CAST(0x0000A09301204990 AS DateTime))
SET IDENTITY_INSERT [dbo].[Remark] OFF
/****** Object:  Table [dbo].[AdminUser]    Script Date: 07/21/2012 18:59:24 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[AdminUser](
	[AdminID] [int] IDENTITY(1,1) NOT NULL,
	[Administrator] [nvarchar](30) NOT NULL,
	[Password] [varchar](max) NOT NULL,
	[CreateDate] [datetime] NOT NULL,
 CONSTRAINT [PK_AdminUser] PRIMARY KEY CLUSTERED 
(
	[AdminID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
SET IDENTITY_INSERT [dbo].[AdminUser] ON
INSERT [dbo].[AdminUser] ([AdminID], [Administrator], [Password], [CreateDate]) VALUES (4, N'administrator', N'mUK+Q2FWQMxRAqAAXJHJmw==', CAST(0x0000A08F013D02B3 AS DateTime))
SET IDENTITY_INSERT [dbo].[AdminUser] OFF
/****** Object:  Table [dbo].[AdminLog]    Script Date: 07/21/2012 18:59:24 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[AdminLog](
	[LogID] [int] IDENTITY(1,1) NOT NULL,
	[Action] [nvarchar](20) NOT NULL,
	[ActionDate] [datetime] NOT NULL,
	[ActionSourceIP] [varchar](20) NULL,
 CONSTRAINT [PK_AdminLog] PRIMARY KEY CLUSTERED 
(
	[LogID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[Account]    Script Date: 07/21/2012 18:59:24 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Account](
	[AccountID] [int] IDENTITY(1,1) NOT NULL,
	[AccountName] [nvarchar](25) NOT NULL,
	[Password] [varchar](max) NOT NULL,
	[Email] [varchar](30) NOT NULL,
	[ActiveCode] [varchar](50) NOT NULL,
	[IsActive] [bit] NOT NULL,
	[IsValidation] [bit] NOT NULL,
	[CreateDate] [datetime] NOT NULL,
 CONSTRAINT [PK_Account] PRIMARY KEY CLUSTERED 
(
	[AccountID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
SET IDENTITY_INSERT [dbo].[Account] ON
INSERT [dbo].[Account] ([AccountID], [AccountName], [Password], [Email], [ActiveCode], [IsActive], [IsValidation], [CreateDate]) VALUES (1, N'weiwei', N'mUK+Q2FWQMxRAqAAXJHJmw==', N'oyjd614@gmail.co', N'32ae9ed2-2e1c-4c35-a93c-8e1c6838f5ab', 1, 1, CAST(0x0000A08C0162F7AE AS DateTime))
INSERT [dbo].[Account] ([AccountID], [AccountName], [Password], [Email], [ActiveCode], [IsActive], [IsValidation], [CreateDate]) VALUES (2, N'chencaixia', N'mUK+Q2FWQMxRAqAAXJHJmw==', N'oyjd614@163.com', N'81c93c15-2d0c-4e0d-bf53-89096e2a11f8', 1, 1, CAST(0x0000A08C01649FD2 AS DateTime))
INSERT [dbo].[Account] ([AccountID], [AccountName], [Password], [Email], [ActiveCode], [IsActive], [IsValidation], [CreateDate]) VALUES (3, N'oyjd614', N'mUK+Q2FWQMxRAqAAXJHJmw==', N'oyjd614@163.com', N'8cf00140-ffd7-46ed-96a5-fc6e004c2158', 1, 1, CAST(0x0000A08D01158332 AS DateTime))
INSERT [dbo].[Account] ([AccountID], [AccountName], [Password], [Email], [ActiveCode], [IsActive], [IsValidation], [CreateDate]) VALUES (4, N'test001', N'mUK+Q2FWQMxRAqAAXJHJmw==', N'oyjd614@163.com', N'6472e827-40ca-43cf-bf05-7dc8b6a4de20', 1, 1, CAST(0x0000A08F012151B2 AS DateTime))
INSERT [dbo].[Account] ([AccountID], [AccountName], [Password], [Email], [ActiveCode], [IsActive], [IsValidation], [CreateDate]) VALUES (5, N'test009', N'mUK+Q2FWQMxRAqAAXJHJmw==', N'oyjd614@gmail.co', N'f7abfd5b-ba82-433f-bb25-75893153f4a0', 1, 1, CAST(0x0000A09200D53422 AS DateTime))
INSERT [dbo].[Account] ([AccountID], [AccountName], [Password], [Email], [ActiveCode], [IsActive], [IsValidation], [CreateDate]) VALUES (6, N'test002', N'mUK+Q2FWQMxRAqAAXJHJmw==', N'oyjd614@gmail.com', N'1308582c-cb34-441d-a7db-4850667d84ff', 0, 0, CAST(0x0000A09300A690A7 AS DateTime))
INSERT [dbo].[Account] ([AccountID], [AccountName], [Password], [Email], [ActiveCode], [IsActive], [IsValidation], [CreateDate]) VALUES (7, N'test003', N'+zHtifesxRfG2sb9vJha1Q==', N'oyjd614@163.com', N'3f1a7a72-7649-4533-b22a-56340e58ce8b', 1, 1, CAST(0x0000A09300A8040B AS DateTime))
INSERT [dbo].[Account] ([AccountID], [AccountName], [Password], [Email], [ActiveCode], [IsActive], [IsValidation], [CreateDate]) VALUES (8, N'dddddddddd', N'mUK+Q2FWQMxRAqAAXJHJmw==', N'oyjd614@163.com', N'd11916c8-420d-4ec6-adfd-a8a54c651d6b', 0, 0, CAST(0x0000A09400BAB6DF AS DateTime))
INSERT [dbo].[Account] ([AccountID], [AccountName], [Password], [Email], [ActiveCode], [IsActive], [IsValidation], [CreateDate]) VALUES (9, N'dddddd', N'cGakD0J3acxDNHqpa3KTGg==', N'dd@163.com', N'70cb5a8a-e346-42d9-8509-45caf570f9d3', 0, 0, CAST(0x0000A09400DF544F AS DateTime))
INSERT [dbo].[Account] ([AccountID], [AccountName], [Password], [Email], [ActiveCode], [IsActive], [IsValidation], [CreateDate]) VALUES (10, N'tommy_wei', N'Mm5+LdtCiV5/sGec36nXGQ==', N'oyjd614@163.com', N'712893d5-5ec0-4fbc-83a6-c10dfb8fd29d', 1, 1, CAST(0x0000A09500A0F95F AS DateTime))
SET IDENTITY_INSERT [dbo].[Account] OFF
/****** Object:  Table [dbo].[EmailInvitation]    Script Date: 07/21/2012 18:59:24 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[EmailInvitation](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[AccountName] [nvarchar](25) NOT NULL,
	[UserID] [int] NOT NULL,
	[Email] [varchar](25) NOT NULL,
	[Content] [ntext] NULL,
	[PartyID] [int] NOT NULL,
	[PartySubject] [nvarchar](30) NULL,
	[IsSent] [bit] NOT NULL,
	[SendDate] [datetime] NOT NULL,
 CONSTRAINT [PK_EmailInvitation] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
SET IDENTITY_INSERT [dbo].[EmailInvitation] ON
INSERT [dbo].[EmailInvitation] ([ID], [AccountName], [UserID], [Email], [Content], [PartyID], [PartySubject], [IsSent], [SendDate]) VALUES (1, N'魏伟', 0, N'oyjd614@163.com', NULL, 2, N'fffffffffff', 1, CAST(0x0000A09300C2D43D AS DateTime))
SET IDENTITY_INSERT [dbo].[EmailInvitation] OFF
/****** Object:  Table [dbo].[Country]    Script Date: 07/21/2012 18:59:24 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Country](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[Country] [nvarchar](15) NULL,
	[Province] [nvarchar](15) NULL,
	[City] [nvarchar](10) NULL,
	[Zone] [nvarchar](10) NULL,
	[Town] [nvarchar](30) NULL,
	[ParentId] [int] NULL,
 CONSTRAINT [PK_Country] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET IDENTITY_INSERT [dbo].[Country] ON
INSERT [dbo].[Country] ([ID], [Country], [Province], [City], [Zone], [Town], [ParentId]) VALUES (1, N'中国', N'上海', N'上海', N'浦东新区', N'张江镇', NULL)
INSERT [dbo].[Country] ([ID], [Country], [Province], [City], [Zone], [Town], [ParentId]) VALUES (2, N'中国', N'上海', N'上海', N'浦东新区', N'塘镇', NULL)
INSERT [dbo].[Country] ([ID], [Country], [Province], [City], [Zone], [Town], [ParentId]) VALUES (3, N'中国', N'上海', N'上海', N'闵行', N'', NULL)
INSERT [dbo].[Country] ([ID], [Country], [Province], [City], [Zone], [Town], [ParentId]) VALUES (4, N'中国', N'新疆', N'乌鲁木齐', N'天山区', NULL, NULL)
SET IDENTITY_INSERT [dbo].[Country] OFF
/****** Object:  Table [dbo].[BreakAppointment]    Script Date: 07/21/2012 18:59:24 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[BreakAppointment](
	[BID] [int] IDENTITY(1,1) NOT NULL,
	[UserID] [int] NOT NULL,
	[PartyID] [int] NOT NULL,
	[CreateDate] [datetime] NOT NULL,
 CONSTRAINT [PK_BreakAppointment] PRIMARY KEY CLUSTERED 
(
	[BID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET IDENTITY_INSERT [dbo].[BreakAppointment] ON
INSERT [dbo].[BreakAppointment] ([BID], [UserID], [PartyID], [CreateDate]) VALUES (1, 2, 1, CAST(0x0000A091015C122E AS DateTime))
SET IDENTITY_INSERT [dbo].[BreakAppointment] OFF
/****** Object:  Table [dbo].[BonusRule]    Script Date: 07/21/2012 18:59:24 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[BonusRule](
	[RuleID] [int] IDENTITY(1,1) NOT NULL,
	[TemporaryDistrain] [decimal](10, 2) NULL,
	[Distrain] [decimal](10, 2) NULL,
	[Drop] [decimal](10, 2) NULL,
	[Rate] [decimal](10, 2) NULL,
	[Publish] [decimal](10, 2) NULL,
	[Inviite] [decimal](10, 2) NULL,
 CONSTRAINT [PK_BonusRule] PRIMARY KEY CLUSTERED 
(
	[RuleID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[BonusLog]    Script Date: 07/21/2012 18:59:24 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[BonusLog](
	[LogID] [int] IDENTITY(1,1) NOT NULL,
	[UserID] [int] NOT NULL,
	[PartyID] [int] NULL,
	[Bonus] [decimal](10, 2) NULL,
	[CreateDate] [datetime] NULL,
 CONSTRAINT [PK_BonusLog] PRIMARY KEY CLUSTERED 
(
	[LogID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET IDENTITY_INSERT [dbo].[BonusLog] ON
INSERT [dbo].[BonusLog] ([LogID], [UserID], [PartyID], [Bonus], [CreateDate]) VALUES (1, 2, 1, CAST(-15.00 AS Decimal(10, 2)), CAST(0x0000A08F0144293E AS DateTime))
INSERT [dbo].[BonusLog] ([LogID], [UserID], [PartyID], [Bonus], [CreateDate]) VALUES (2, 2, 1, CAST(-15.00 AS Decimal(10, 2)), CAST(0x0000A08F016A5261 AS DateTime))
INSERT [dbo].[BonusLog] ([LogID], [UserID], [PartyID], [Bonus], [CreateDate]) VALUES (3, 2, 1, CAST(-15.00 AS Decimal(10, 2)), CAST(0x0000A08F016A8B38 AS DateTime))
INSERT [dbo].[BonusLog] ([LogID], [UserID], [PartyID], [Bonus], [CreateDate]) VALUES (4, 2, 1, CAST(-15.00 AS Decimal(10, 2)), CAST(0x0000A08F016A95DC AS DateTime))
INSERT [dbo].[BonusLog] ([LogID], [UserID], [PartyID], [Bonus], [CreateDate]) VALUES (5, 2, 1, CAST(-15.00 AS Decimal(10, 2)), CAST(0x0000A08F016AABE0 AS DateTime))
INSERT [dbo].[BonusLog] ([LogID], [UserID], [PartyID], [Bonus], [CreateDate]) VALUES (6, 2, 1, CAST(-15.00 AS Decimal(10, 2)), CAST(0x0000A08F016AC2A4 AS DateTime))
INSERT [dbo].[BonusLog] ([LogID], [UserID], [PartyID], [Bonus], [CreateDate]) VALUES (7, 2, 0, CAST(-2.00 AS Decimal(10, 2)), CAST(0x0000A08F016C3763 AS DateTime))
INSERT [dbo].[BonusLog] ([LogID], [UserID], [PartyID], [Bonus], [CreateDate]) VALUES (8, 2, 1, CAST(-15.00 AS Decimal(10, 2)), CAST(0x0000A08F016CBFC8 AS DateTime))
INSERT [dbo].[BonusLog] ([LogID], [UserID], [PartyID], [Bonus], [CreateDate]) VALUES (9, 2, 1, CAST(-15.00 AS Decimal(10, 2)), CAST(0x0000A08F016CDD11 AS DateTime))
INSERT [dbo].[BonusLog] ([LogID], [UserID], [PartyID], [Bonus], [CreateDate]) VALUES (10, 2, 1, CAST(-15.00 AS Decimal(10, 2)), CAST(0x0000A08F01772810 AS DateTime))
INSERT [dbo].[BonusLog] ([LogID], [UserID], [PartyID], [Bonus], [CreateDate]) VALUES (11, 2, 1, CAST(35.00 AS Decimal(10, 2)), CAST(0x0000A08F01781073 AS DateTime))
INSERT [dbo].[BonusLog] ([LogID], [UserID], [PartyID], [Bonus], [CreateDate]) VALUES (12, 2, 1, CAST(-15.00 AS Decimal(10, 2)), CAST(0x0000A090010B5E89 AS DateTime))
INSERT [dbo].[BonusLog] ([LogID], [UserID], [PartyID], [Bonus], [CreateDate]) VALUES (13, 2, 1, CAST(-15.00 AS Decimal(10, 2)), CAST(0x0000A091015C1251 AS DateTime))
INSERT [dbo].[BonusLog] ([LogID], [UserID], [PartyID], [Bonus], [CreateDate]) VALUES (14, 3, 2, CAST(-15.00 AS Decimal(10, 2)), CAST(0x0000A09201058CE7 AS DateTime))
INSERT [dbo].[BonusLog] ([LogID], [UserID], [PartyID], [Bonus], [CreateDate]) VALUES (15, 1, 2, CAST(-15.00 AS Decimal(10, 2)), CAST(0x0000A0920105CC16 AS DateTime))
INSERT [dbo].[BonusLog] ([LogID], [UserID], [PartyID], [Bonus], [CreateDate]) VALUES (16, 3, 0, CAST(-2.00 AS Decimal(10, 2)), CAST(0x0000A0920106372C AS DateTime))
INSERT [dbo].[BonusLog] ([LogID], [UserID], [PartyID], [Bonus], [CreateDate]) VALUES (17, 3, 0, CAST(-2.00 AS Decimal(10, 2)), CAST(0x0000A092010637B5 AS DateTime))
INSERT [dbo].[BonusLog] ([LogID], [UserID], [PartyID], [Bonus], [CreateDate]) VALUES (18, 3, 0, CAST(-2.00 AS Decimal(10, 2)), CAST(0x0000A09201063857 AS DateTime))
INSERT [dbo].[BonusLog] ([LogID], [UserID], [PartyID], [Bonus], [CreateDate]) VALUES (19, 3, 0, CAST(-2.00 AS Decimal(10, 2)), CAST(0x0000A092010638F7 AS DateTime))
INSERT [dbo].[BonusLog] ([LogID], [UserID], [PartyID], [Bonus], [CreateDate]) VALUES (20, 7, 2, CAST(-15.00 AS Decimal(10, 2)), CAST(0x0000A09300AB74EF AS DateTime))
INSERT [dbo].[BonusLog] ([LogID], [UserID], [PartyID], [Bonus], [CreateDate]) VALUES (21, 1, 0, CAST(-2.00 AS Decimal(10, 2)), CAST(0x0000A09300AC79FE AS DateTime))
INSERT [dbo].[BonusLog] ([LogID], [UserID], [PartyID], [Bonus], [CreateDate]) VALUES (22, 1, 0, CAST(-2.00 AS Decimal(10, 2)), CAST(0x0000A09300AC7A93 AS DateTime))
INSERT [dbo].[BonusLog] ([LogID], [UserID], [PartyID], [Bonus], [CreateDate]) VALUES (23, 1, 0, CAST(-2.00 AS Decimal(10, 2)), CAST(0x0000A09300AC7B39 AS DateTime))
INSERT [dbo].[BonusLog] ([LogID], [UserID], [PartyID], [Bonus], [CreateDate]) VALUES (24, 1, 0, CAST(-2.00 AS Decimal(10, 2)), CAST(0x0000A09300AC7BC7 AS DateTime))
INSERT [dbo].[BonusLog] ([LogID], [UserID], [PartyID], [Bonus], [CreateDate]) VALUES (25, 1, 2, CAST(-15.00 AS Decimal(10, 2)), CAST(0x0000A09300FAB89B AS DateTime))
INSERT [dbo].[BonusLog] ([LogID], [UserID], [PartyID], [Bonus], [CreateDate]) VALUES (26, 2, 3, CAST(-15.00 AS Decimal(10, 2)), CAST(0x0000A093011DB73F AS DateTime))
SET IDENTITY_INSERT [dbo].[BonusLog] OFF
/****** Object:  Table [dbo].[PartyType]    Script Date: 07/21/2012 18:59:24 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[PartyType](
	[PID] [int] IDENTITY(1,1) NOT NULL,
	[Name] [nvarchar](20) NOT NULL,
	[Type] [int] NOT NULL,
 CONSTRAINT [PK_PartyType] PRIMARY KEY CLUSTERED 
(
	[PID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET IDENTITY_INSERT [dbo].[PartyType] ON
INSERT [dbo].[PartyType] ([PID], [Name], [Type]) VALUES (1, N'体育活动', 0)
INSERT [dbo].[PartyType] ([PID], [Name], [Type]) VALUES (2, N'单身男女', 1)
INSERT [dbo].[PartyType] ([PID], [Name], [Type]) VALUES (3, N'老乡活动', 2)
INSERT [dbo].[PartyType] ([PID], [Name], [Type]) VALUES (4, N'其他', 3)
SET IDENTITY_INSERT [dbo].[PartyType] OFF
/****** Object:  Table [dbo].[Party]    Script Date: 07/21/2012 18:59:24 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Party](
	[PartyID] [int] IDENTITY(1,1) NOT NULL,
	[Status] [int] NOT NULL,
	[PartyType] [int] NOT NULL,
	[Subject] [nvarchar](30) NOT NULL,
	[Content] [ntext] NULL,
	[PhotoUrl] [nvarchar](20) NULL,
	[Modality] [nvarchar](20) NULL,
	[PartyDate] [datetime] NULL,
	[Location] [nvarchar](100) NULL,
	[Address] [nvarchar](150) NULL,
	[Area] [nvarchar](50) NULL,
	[CreateDate] [datetime] NOT NULL,
	[MemberCount] [int] NULL,
	[Expense] [decimal](10, 2) NULL,
	[PaymentType] [int] NOT NULL,
	[IsSuccess] [bit] NOT NULL,
 CONSTRAINT [PK_Party] PRIMARY KEY CLUSTERED 
(
	[PartyID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
SET IDENTITY_INSERT [dbo].[Party] ON
INSERT [dbo].[Party] ([PartyID], [Status], [PartyType], [Subject], [Content], [PhotoUrl], [Modality], [PartyDate], [Location], [Address], [Area], [CreateDate], [MemberCount], [Expense], [PaymentType], [IsSuccess]) VALUES (1, 1, 1, N'唱歌', N'对方答复地方地方的', NULL, N'唱歌', CAST(0x0000A09500000000 AS DateTime), N'对方答复', N'对方答复', N'', CAST(0x0000A08F013CAB8D AS DateTime), 10, CAST(500.00 AS Decimal(10, 2)), 2, 1)
INSERT [dbo].[Party] ([PartyID], [Status], [PartyType], [Subject], [Content], [PhotoUrl], [Modality], [PartyDate], [Location], [Address], [Area], [CreateDate], [MemberCount], [Expense], [PaymentType], [IsSuccess]) VALUES (2, 1, 1, N'fffffffffff', N'dfdfdf', NULL, N'11', CAST(0x0000A09300000000 AS DateTime), N'1', N'ddddddddddd', N'', CAST(0x0000A0920103450A AS DateTime), 10, CAST(200.00 AS Decimal(10, 2)), 1, 1)
INSERT [dbo].[Party] ([PartyID], [Status], [PartyType], [Subject], [Content], [PhotoUrl], [Modality], [PartyDate], [Location], [Address], [Area], [CreateDate], [MemberCount], [Expense], [PaymentType], [IsSuccess]) VALUES (3, 1, 0, N'去体育馆踢球', N'地方地方地方地方飞大幅度发大幅度', NULL, N'踢球', CAST(0x0000A09500000000 AS DateTime), N'上海资源体育中心', N'上海资源体育中心 100 号', N'', CAST(0x0000A0930119EA42 AS DateTime), 22, CAST(400.00 AS Decimal(10, 2)), 1, 1)
SET IDENTITY_INSERT [dbo].[Party] OFF
/****** Object:  Table [dbo].[Notice]    Script Date: 07/21/2012 18:59:24 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Notice](
	[NoticeID] [int] IDENTITY(1,1) NOT NULL,
	[Subject] [nvarchar](20) NOT NULL,
	[Content] [ntext] NULL,
	[CreateDate] [datetime] NOT NULL,
 CONSTRAINT [PK_Notice] PRIMARY KEY CLUSTERED 
(
	[NoticeID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
/****** Object:  Table [dbo].[Modality]    Script Date: 07/21/2012 18:59:24 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Modality](
	[MID] [int] IDENTITY(1,1) NOT NULL,
	[PID] [int] NOT NULL,
	[Name] [nvarchar](20) NOT NULL,
 CONSTRAINT [PK_Modality] PRIMARY KEY CLUSTERED 
(
	[MID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET IDENTITY_INSERT [dbo].[Modality] ON
INSERT [dbo].[Modality] ([MID], [PID], [Name]) VALUES (2, 1, N'tet')
INSERT [dbo].[Modality] ([MID], [PID], [Name]) VALUES (3, 1, N'ts')
INSERT [dbo].[Modality] ([MID], [PID], [Name]) VALUES (4, 1, N'dfdf')
INSERT [dbo].[Modality] ([MID], [PID], [Name]) VALUES (5, 1, N'test')
INSERT [dbo].[Modality] ([MID], [PID], [Name]) VALUES (6, 2, N'dd')
INSERT [dbo].[Modality] ([MID], [PID], [Name]) VALUES (7, 2, N'dfdf')
INSERT [dbo].[Modality] ([MID], [PID], [Name]) VALUES (8, 3, N'dfdf')
INSERT [dbo].[Modality] ([MID], [PID], [Name]) VALUES (9, 3, N'dfff')
INSERT [dbo].[Modality] ([MID], [PID], [Name]) VALUES (10, 1, N'f')
INSERT [dbo].[Modality] ([MID], [PID], [Name]) VALUES (11, 1, N'hhh')
SET IDENTITY_INSERT [dbo].[Modality] OFF
/****** Object:  Table [dbo].[User]    Script Date: 07/21/2012 18:59:24 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[User](
	[UserID] [int] IDENTITY(1,1) NOT NULL,
	[AccountID] [int] NOT NULL,
	[AccountName] [nvarchar](25) NOT NULL,
	[Name] [nvarchar](20) NULL,
	[Gender] [bit] NULL,
	[Birthday] [datetime] NULL,
	[Age] [smallint] NULL,
	[Location] [nvarchar](20) NULL,
	[HomePlace] [nvarchar](30) NULL,
	[Marriage] [bit] NULL,
	[NativePlace] [nvarchar](40) NULL,
	[Stature] [nvarchar](10) NULL,
	[Weight] [int] NULL,
	[Education] [nvarchar](10) NULL,
	[Job] [nvarchar](20) NULL,
	[Income] [nvarchar](15) NULL,
	[Position] [nvarchar](20) NULL,
	[Industry] [nvarchar](50) NULL,
	[Car] [bit] NULL,
	[Parents] [nvarchar](20) NULL,
	[Photo] [nvarchar](50) NULL,
	[Phone] [varchar](15) NULL,
	[IM] [varchar](18) NULL,
	[Introduction] [nvarchar](300) NULL,
	[IsValidation] [bit] NOT NULL,
	[CreateDate] [datetime] NOT NULL,
 CONSTRAINT [PK_User] PRIMARY KEY CLUSTERED 
(
	[UserID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY],
 CONSTRAINT [UQ_User_AccountID] UNIQUE NONCLUSTERED 
(
	[AccountID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
SET IDENTITY_INSERT [dbo].[User] ON
INSERT [dbo].[User] ([UserID], [AccountID], [AccountName], [Name], [Gender], [Birthday], [Age], [Location], [HomePlace], [Marriage], [NativePlace], [Stature], [Weight], [Education], [Job], [Income], [Position], [Industry], [Car], [Parents], [Photo], [Phone], [IM], [Introduction], [IsValidation], [CreateDate]) VALUES (1, 1, N'weiwei', N'地方', 0, CAST(0x0000A09400000000 AS DateTime), NULL, N'上海 上海 浦东新区', NULL, 0, N'f', N'170', 60, N'研究生', NULL, N'8000以上', NULL, NULL, 0, N'一般', N'p1ixnjq5.pgq.jpg', NULL, NULL, NULL, 1, CAST(0x0000A08C0162F7AE AS DateTime))
INSERT [dbo].[User] ([UserID], [AccountID], [AccountName], [Name], [Gender], [Birthday], [Age], [Location], [HomePlace], [Marriage], [NativePlace], [Stature], [Weight], [Education], [Job], [Income], [Position], [Industry], [Car], [Parents], [Photo], [Phone], [IM], [Introduction], [IsValidation], [CreateDate]) VALUES (2, 2, N'chencaixia', N'陈彩霞', 1, CAST(0x00007A0500000000 AS DateTime), NULL, N'地方地方地方', NULL, 0, N'大幅度', N'160', 50, N'高中', N'地方', N'5000-8000', N'地方', N' 地方', 0, N'良好', N'2pmmz3rf.g0i.jpg', N'18217229563', N'67235808', N'大幅度', 1, CAST(0x0000A08C01649FD2 AS DateTime))
INSERT [dbo].[User] ([UserID], [AccountID], [AccountName], [Name], [Gender], [Birthday], [Age], [Location], [HomePlace], [Marriage], [NativePlace], [Stature], [Weight], [Education], [Job], [Income], [Position], [Industry], [Car], [Parents], [Photo], [Phone], [IM], [Introduction], [IsValidation], [CreateDate]) VALUES (3, 3, N'oyjd614', N'欧阳简单', 0, CAST(0x0000798500000000 AS DateTime), NULL, N'shanghai', NULL, 1, N'大幅度', N'170', 70, N'研究生', N'大幅度', N'5000-8000', N'大幅度', N'对方答复', 1, N'良好', N'vldwyjgh.rbv.jpg', N'18217229563', N'67235808', N'地方地方地方大幅度', 1, CAST(0x0000A08D01158333 AS DateTime))
INSERT [dbo].[User] ([UserID], [AccountID], [AccountName], [Name], [Gender], [Birthday], [Age], [Location], [HomePlace], [Marriage], [NativePlace], [Stature], [Weight], [Education], [Job], [Income], [Position], [Industry], [Car], [Parents], [Photo], [Phone], [IM], [Introduction], [IsValidation], [CreateDate]) VALUES (4, 4, N'test001', NULL, 0, CAST(0x0000798500000000 AS DateTime), 27, N'df', NULL, 0, NULL, NULL, NULL, N'高中', NULL, N'5000以下', NULL, NULL, NULL, N'-1', N'test', NULL, NULL, NULL, 1, CAST(0x0000A08F012151B2 AS DateTime))
INSERT [dbo].[User] ([UserID], [AccountID], [AccountName], [Name], [Gender], [Birthday], [Age], [Location], [HomePlace], [Marriage], [NativePlace], [Stature], [Weight], [Education], [Job], [Income], [Position], [Industry], [Car], [Parents], [Photo], [Phone], [IM], [Introduction], [IsValidation], [CreateDate]) VALUES (5, 5, N'test009', NULL, 0, CAST(0x0000A09300000000 AS DateTime), 27, N'oyjd', NULL, 0, NULL, NULL, NULL, N'高中', NULL, N'5000以下', NULL, NULL, NULL, N'-1', N'none_75_75.png', NULL, NULL, NULL, 1, CAST(0x0000A09200D53423 AS DateTime))
INSERT [dbo].[User] ([UserID], [AccountID], [AccountName], [Name], [Gender], [Birthday], [Age], [Location], [HomePlace], [Marriage], [NativePlace], [Stature], [Weight], [Education], [Job], [Income], [Position], [Industry], [Car], [Parents], [Photo], [Phone], [IM], [Introduction], [IsValidation], [CreateDate]) VALUES (6, 6, N'test002', NULL, 0, CAST(0x0000A09300000000 AS DateTime), 28, N'啥地方大幅度对方答复对方答复地', NULL, 0, N'新疆', N'170', 60, N'大学', N'工程师', N'5000-8000', N'经理', N'对方答复', 0, N'良好', N'none_75_75.png', NULL, NULL, NULL, 0, CAST(0x0000A09300A690A7 AS DateTime))
INSERT [dbo].[User] ([UserID], [AccountID], [AccountName], [Name], [Gender], [Birthday], [Age], [Location], [HomePlace], [Marriage], [NativePlace], [Stature], [Weight], [Education], [Job], [Income], [Position], [Industry], [Car], [Parents], [Photo], [Phone], [IM], [Introduction], [IsValidation], [CreateDate]) VALUES (7, 7, N'test003', N'测试账号3', 1, CAST(0x0000A09400000000 AS DateTime), NULL, N'dfdf', NULL, 0, N'dfdf', N'170', 50, N'大学', N'dfdf', N'5000-8000', N'dfdf', N'dfdf', 1, N'良好', N'f2mwu534.lsv.jpg', NULL, NULL, NULL, 1, CAST(0x0000A09300A8040B AS DateTime))
INSERT [dbo].[User] ([UserID], [AccountID], [AccountName], [Name], [Gender], [Birthday], [Age], [Location], [HomePlace], [Marriage], [NativePlace], [Stature], [Weight], [Education], [Job], [Income], [Position], [Industry], [Car], [Parents], [Photo], [Phone], [IM], [Introduction], [IsValidation], [CreateDate]) VALUES (8, 8, N'dddddddddd', NULL, 0, CAST(0x0000A08C00000000 AS DateTime), 22, N'新疆 乌鲁木齐 浦东新区', NULL, 0, NULL, NULL, NULL, N'高中', NULL, N'5000以下', NULL, NULL, NULL, N'0', N'none_75_75.png', NULL, NULL, NULL, 0, CAST(0x0000A09400BAB6DF AS DateTime))
INSERT [dbo].[User] ([UserID], [AccountID], [AccountName], [Name], [Gender], [Birthday], [Age], [Location], [HomePlace], [Marriage], [NativePlace], [Stature], [Weight], [Education], [Job], [Income], [Position], [Industry], [Car], [Parents], [Photo], [Phone], [IM], [Introduction], [IsValidation], [CreateDate]) VALUES (9, 9, N'dddddd', NULL, 0, CAST(0x00009FD500000000 AS DateTime), 22, N'上海 上海 浦东新区', NULL, 0, NULL, NULL, NULL, N'高中', NULL, N'5000以下', NULL, NULL, NULL, N'0', N'none_75_75.png', NULL, NULL, NULL, 0, CAST(0x0000A09400DF544F AS DateTime))
INSERT [dbo].[User] ([UserID], [AccountID], [AccountName], [Name], [Gender], [Birthday], [Age], [Location], [HomePlace], [Marriage], [NativePlace], [Stature], [Weight], [Education], [Job], [Income], [Position], [Industry], [Car], [Parents], [Photo], [Phone], [IM], [Introduction], [IsValidation], [CreateDate]) VALUES (10, 10, N'tommy_wei', N'dfdf', 0, CAST(0x0000A08C00000000 AS DateTime), NULL, N'上海 上海 闵行', NULL, 0, N'新疆', N'170', 60, N'研究生', N'产品经理', N'8000以上', N'产品经理', N'IT电信', 1, N'良好', N'none_75_75.png', N'18217229563', N'67235808', N'test', 1, CAST(0x0000A09500A0F95F AS DateTime))
SET IDENTITY_INSERT [dbo].[User] OFF
/****** Object:  Table [dbo].[UserView]    Script Date: 07/21/2012 18:59:24 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[UserView](
	[ViewID] [int] IDENTITY(1,1) NOT NULL,
	[UserID] [int] NOT NULL,
	[IP] [varchar](20) NULL,
	[ViewDate] [datetime] NOT NULL,
 CONSTRAINT [PK_UserView] PRIMARY KEY CLUSTERED 
(
	[ViewID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
SET IDENTITY_INSERT [dbo].[UserView] ON
INSERT [dbo].[UserView] ([ViewID], [UserID], [IP], [ViewDate]) VALUES (1, 2, N'::1', CAST(0x0000A08C0164E79B AS DateTime))
INSERT [dbo].[UserView] ([ViewID], [UserID], [IP], [ViewDate]) VALUES (2, 2, N'::1', CAST(0x0000A08C016523B4 AS DateTime))
INSERT [dbo].[UserView] ([ViewID], [UserID], [IP], [ViewDate]) VALUES (3, 2, N'::1', CAST(0x0000A08C01655748 AS DateTime))
INSERT [dbo].[UserView] ([ViewID], [UserID], [IP], [ViewDate]) VALUES (4, 1, N'::1', CAST(0x0000A08C016562F3 AS DateTime))
INSERT [dbo].[UserView] ([ViewID], [UserID], [IP], [ViewDate]) VALUES (5, 2, N'::1', CAST(0x0000A08C01685DEF AS DateTime))
INSERT [dbo].[UserView] ([ViewID], [UserID], [IP], [ViewDate]) VALUES (6, 1, N'::1', CAST(0x0000A08C0168656A AS DateTime))
INSERT [dbo].[UserView] ([ViewID], [UserID], [IP], [ViewDate]) VALUES (7, 1, N'::1', CAST(0x0000A08C01687039 AS DateTime))
INSERT [dbo].[UserView] ([ViewID], [UserID], [IP], [ViewDate]) VALUES (8, 1, N'::1', CAST(0x0000A08C0168F9A8 AS DateTime))
INSERT [dbo].[UserView] ([ViewID], [UserID], [IP], [ViewDate]) VALUES (9, 1, N'::1', CAST(0x0000A08C0174FF28 AS DateTime))
INSERT [dbo].[UserView] ([ViewID], [UserID], [IP], [ViewDate]) VALUES (10, 1, N'::1', CAST(0x0000A08C01753EC4 AS DateTime))
INSERT [dbo].[UserView] ([ViewID], [UserID], [IP], [ViewDate]) VALUES (11, 1, N'::1', CAST(0x0000A08C01754B8C AS DateTime))
INSERT [dbo].[UserView] ([ViewID], [UserID], [IP], [ViewDate]) VALUES (12, 1, N'::1', CAST(0x0000A08C0178270F AS DateTime))
INSERT [dbo].[UserView] ([ViewID], [UserID], [IP], [ViewDate]) VALUES (13, 1, N'::1', CAST(0x0000A08C01784C22 AS DateTime))
INSERT [dbo].[UserView] ([ViewID], [UserID], [IP], [ViewDate]) VALUES (14, 2, N'::1', CAST(0x0000A08D00D19511 AS DateTime))
INSERT [dbo].[UserView] ([ViewID], [UserID], [IP], [ViewDate]) VALUES (15, 1, N'::1', CAST(0x0000A08D00D1CA3B AS DateTime))
INSERT [dbo].[UserView] ([ViewID], [UserID], [IP], [ViewDate]) VALUES (16, 2, N'::1', CAST(0x0000A08D0108B7F5 AS DateTime))
INSERT [dbo].[UserView] ([ViewID], [UserID], [IP], [ViewDate]) VALUES (17, 2, N'::1', CAST(0x0000A08D0108EC46 AS DateTime))
INSERT [dbo].[UserView] ([ViewID], [UserID], [IP], [ViewDate]) VALUES (18, 2, N'::1', CAST(0x0000A08D0109F29B AS DateTime))
INSERT [dbo].[UserView] ([ViewID], [UserID], [IP], [ViewDate]) VALUES (19, 1, N'::1', CAST(0x0000A08D010A4358 AS DateTime))
INSERT [dbo].[UserView] ([ViewID], [UserID], [IP], [ViewDate]) VALUES (20, 1, N'::1', CAST(0x0000A08D010AE707 AS DateTime))
INSERT [dbo].[UserView] ([ViewID], [UserID], [IP], [ViewDate]) VALUES (21, 2, N'::1', CAST(0x0000A08D010D3DD3 AS DateTime))
INSERT [dbo].[UserView] ([ViewID], [UserID], [IP], [ViewDate]) VALUES (22, 1, N'::1', CAST(0x0000A08F012B53BA AS DateTime))
INSERT [dbo].[UserView] ([ViewID], [UserID], [IP], [ViewDate]) VALUES (23, 2, N'::1', CAST(0x0000A08F012B644D AS DateTime))
INSERT [dbo].[UserView] ([ViewID], [UserID], [IP], [ViewDate]) VALUES (24, 2, N'::1', CAST(0x0000A08F012B7E2F AS DateTime))
INSERT [dbo].[UserView] ([ViewID], [UserID], [IP], [ViewDate]) VALUES (25, 2, N'::1', CAST(0x0000A08F012BEA1B AS DateTime))
INSERT [dbo].[UserView] ([ViewID], [UserID], [IP], [ViewDate]) VALUES (26, 2, N'::1', CAST(0x0000A08F012CF318 AS DateTime))
INSERT [dbo].[UserView] ([ViewID], [UserID], [IP], [ViewDate]) VALUES (27, 1, N'::1', CAST(0x0000A08F012D14A4 AS DateTime))
INSERT [dbo].[UserView] ([ViewID], [UserID], [IP], [ViewDate]) VALUES (28, 2, N'::1', CAST(0x0000A08F013AB0F4 AS DateTime))
INSERT [dbo].[UserView] ([ViewID], [UserID], [IP], [ViewDate]) VALUES (29, 2, N'::1', CAST(0x0000A08F0145410A AS DateTime))
INSERT [dbo].[UserView] ([ViewID], [UserID], [IP], [ViewDate]) VALUES (30, 2, N'::1', CAST(0x0000A090010AA94F AS DateTime))
INSERT [dbo].[UserView] ([ViewID], [UserID], [IP], [ViewDate]) VALUES (31, 1, N'::1', CAST(0x0000A09001107E4D AS DateTime))
INSERT [dbo].[UserView] ([ViewID], [UserID], [IP], [ViewDate]) VALUES (32, 1, N'::1', CAST(0x0000A091018A950F AS DateTime))
INSERT [dbo].[UserView] ([ViewID], [UserID], [IP], [ViewDate]) VALUES (33, 2, N'::1', CAST(0x0000A09200063980 AS DateTime))
INSERT [dbo].[UserView] ([ViewID], [UserID], [IP], [ViewDate]) VALUES (34, 2, N'::1', CAST(0x0000A09200FCB20A AS DateTime))
INSERT [dbo].[UserView] ([ViewID], [UserID], [IP], [ViewDate]) VALUES (35, 2, N'::1', CAST(0x0000A09200FCDADE AS DateTime))
INSERT [dbo].[UserView] ([ViewID], [UserID], [IP], [ViewDate]) VALUES (36, 2, N'::1', CAST(0x0000A09200FD3438 AS DateTime))
INSERT [dbo].[UserView] ([ViewID], [UserID], [IP], [ViewDate]) VALUES (37, 2, N'::1', CAST(0x0000A09200FD4A77 AS DateTime))
INSERT [dbo].[UserView] ([ViewID], [UserID], [IP], [ViewDate]) VALUES (38, 2, N'::1', CAST(0x0000A09201005DD8 AS DateTime))
INSERT [dbo].[UserView] ([ViewID], [UserID], [IP], [ViewDate]) VALUES (39, 2, N'::1', CAST(0x0000A0920100B557 AS DateTime))
INSERT [dbo].[UserView] ([ViewID], [UserID], [IP], [ViewDate]) VALUES (40, 2, N'::1', CAST(0x0000A0920100CF2B AS DateTime))
INSERT [dbo].[UserView] ([ViewID], [UserID], [IP], [ViewDate]) VALUES (41, 1, N'::1', CAST(0x0000A09300ACEAB8 AS DateTime))
INSERT [dbo].[UserView] ([ViewID], [UserID], [IP], [ViewDate]) VALUES (42, 1, N'::1', CAST(0x0000A09300ADF0BF AS DateTime))
INSERT [dbo].[UserView] ([ViewID], [UserID], [IP], [ViewDate]) VALUES (43, 1, N'::1', CAST(0x0000A09301099363 AS DateTime))
INSERT [dbo].[UserView] ([ViewID], [UserID], [IP], [ViewDate]) VALUES (44, 2, N'::1', CAST(0x0000A093012074E2 AS DateTime))
INSERT [dbo].[UserView] ([ViewID], [UserID], [IP], [ViewDate]) VALUES (45, 7, N'::1', CAST(0x0000A09301295573 AS DateTime))
INSERT [dbo].[UserView] ([ViewID], [UserID], [IP], [ViewDate]) VALUES (46, 3, N'::1', CAST(0x0000A09301295A96 AS DateTime))
INSERT [dbo].[UserView] ([ViewID], [UserID], [IP], [ViewDate]) VALUES (47, 2, N'::1', CAST(0x0000A09301296062 AS DateTime))
INSERT [dbo].[UserView] ([ViewID], [UserID], [IP], [ViewDate]) VALUES (48, 2, N'::1', CAST(0x0000A093012BCE08 AS DateTime))
INSERT [dbo].[UserView] ([ViewID], [UserID], [IP], [ViewDate]) VALUES (49, 2, N'::1', CAST(0x0000A093012BFAA1 AS DateTime))
INSERT [dbo].[UserView] ([ViewID], [UserID], [IP], [ViewDate]) VALUES (50, 2, N'::1', CAST(0x0000A093012C39CD AS DateTime))
INSERT [dbo].[UserView] ([ViewID], [UserID], [IP], [ViewDate]) VALUES (51, 7, N'::1', CAST(0x0000A093012F6F82 AS DateTime))
INSERT [dbo].[UserView] ([ViewID], [UserID], [IP], [ViewDate]) VALUES (52, 2, N'::1', CAST(0x0000A093012F7EA0 AS DateTime))
INSERT [dbo].[UserView] ([ViewID], [UserID], [IP], [ViewDate]) VALUES (53, 3, N'::1', CAST(0x0000A093012F8360 AS DateTime))
INSERT [dbo].[UserView] ([ViewID], [UserID], [IP], [ViewDate]) VALUES (54, 3, N'::1', CAST(0x0000A093012F8669 AS DateTime))
INSERT [dbo].[UserView] ([ViewID], [UserID], [IP], [ViewDate]) VALUES (55, 5, N'::1', CAST(0x0000A093012F88A9 AS DateTime))
INSERT [dbo].[UserView] ([ViewID], [UserID], [IP], [ViewDate]) VALUES (56, 5, N'::1', CAST(0x0000A093012FF765 AS DateTime))
INSERT [dbo].[UserView] ([ViewID], [UserID], [IP], [ViewDate]) VALUES (57, 5, N'::1', CAST(0x0000A0930130106A AS DateTime))
INSERT [dbo].[UserView] ([ViewID], [UserID], [IP], [ViewDate]) VALUES (58, 3, N'::1', CAST(0x0000A09400AE0092 AS DateTime))
INSERT [dbo].[UserView] ([ViewID], [UserID], [IP], [ViewDate]) VALUES (59, 2, N'::1', CAST(0x0000A09500AD7A02 AS DateTime))
INSERT [dbo].[UserView] ([ViewID], [UserID], [IP], [ViewDate]) VALUES (60, 2, N'::1', CAST(0x0000A09500B00DBE AS DateTime))
INSERT [dbo].[UserView] ([ViewID], [UserID], [IP], [ViewDate]) VALUES (61, 2, N'::1', CAST(0x0000A09500B11596 AS DateTime))
INSERT [dbo].[UserView] ([ViewID], [UserID], [IP], [ViewDate]) VALUES (62, 2, N'::1', CAST(0x0000A09500B11AED AS DateTime))
INSERT [dbo].[UserView] ([ViewID], [UserID], [IP], [ViewDate]) VALUES (63, 2, N'::1', CAST(0x0000A09500B15BD9 AS DateTime))
INSERT [dbo].[UserView] ([ViewID], [UserID], [IP], [ViewDate]) VALUES (64, 2, N'::1', CAST(0x0000A09500B31653 AS DateTime))
INSERT [dbo].[UserView] ([ViewID], [UserID], [IP], [ViewDate]) VALUES (65, 2, N'::1', CAST(0x0000A09500B32E59 AS DateTime))
INSERT [dbo].[UserView] ([ViewID], [UserID], [IP], [ViewDate]) VALUES (66, 2, N'::1', CAST(0x0000A09500B3508C AS DateTime))
INSERT [dbo].[UserView] ([ViewID], [UserID], [IP], [ViewDate]) VALUES (67, 2, N'::1', CAST(0x0000A09500B39C47 AS DateTime))
SET IDENTITY_INSERT [dbo].[UserView] OFF
/****** Object:  Table [dbo].[UserPartyAssociation]    Script Date: 07/21/2012 18:59:24 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[UserPartyAssociation](
	[UPAID] [int] IDENTITY(1,1) NOT NULL,
	[UserID] [int] NOT NULL,
	[PartyID] [int] NOT NULL,
	[IsLead] [bigint] NULL,
	[AssociationDate] [datetime] NOT NULL,
 CONSTRAINT [PK_UserPartyAssociation] PRIMARY KEY CLUSTERED 
(
	[UPAID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET IDENTITY_INSERT [dbo].[UserPartyAssociation] ON
INSERT [dbo].[UserPartyAssociation] ([UPAID], [UserID], [PartyID], [IsLead], [AssociationDate]) VALUES (1, 1, 1, 1, CAST(0x0000A08F013CABA2 AS DateTime))
INSERT [dbo].[UserPartyAssociation] ([UPAID], [UserID], [PartyID], [IsLead], [AssociationDate]) VALUES (7, 2, 1, 0, CAST(0x0000A090010B5E1C AS DateTime))
INSERT [dbo].[UserPartyAssociation] ([UPAID], [UserID], [PartyID], [IsLead], [AssociationDate]) VALUES (8, 2, 2, 1, CAST(0x0000A09201034511 AS DateTime))
INSERT [dbo].[UserPartyAssociation] ([UPAID], [UserID], [PartyID], [IsLead], [AssociationDate]) VALUES (9, 3, 2, 0, CAST(0x0000A09201058CC3 AS DateTime))
INSERT [dbo].[UserPartyAssociation] ([UPAID], [UserID], [PartyID], [IsLead], [AssociationDate]) VALUES (11, 7, 2, 0, CAST(0x0000A09300AB74BC AS DateTime))
INSERT [dbo].[UserPartyAssociation] ([UPAID], [UserID], [PartyID], [IsLead], [AssociationDate]) VALUES (12, 7, 2, 0, CAST(0x0000A09300ACF93A AS DateTime))
INSERT [dbo].[UserPartyAssociation] ([UPAID], [UserID], [PartyID], [IsLead], [AssociationDate]) VALUES (13, 5, 3, 1, CAST(0x0000A0930119EA4C AS DateTime))
INSERT [dbo].[UserPartyAssociation] ([UPAID], [UserID], [PartyID], [IsLead], [AssociationDate]) VALUES (14, 2, 3, 0, CAST(0x0000A093011DB725 AS DateTime))
SET IDENTITY_INSERT [dbo].[UserPartyAssociation] OFF
/****** Object:  Table [dbo].[Photo]    Script Date: 07/21/2012 18:59:24 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Photo](
	[PhotoID] [int] IDENTITY(1,1) NOT NULL,
	[UserID] [int] NOT NULL,
	[Url] [nvarchar](30) NULL,
	[Desc] [nvarchar](20) NULL,
	[IsMain] [bit] NOT NULL,
	[CreateDate] [datetime] NOT NULL,
 CONSTRAINT [PK_Photo] PRIMARY KEY CLUSTERED 
(
	[PhotoID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET IDENTITY_INSERT [dbo].[Photo] ON
INSERT [dbo].[Photo] ([PhotoID], [UserID], [Url], [Desc], [IsMain], [CreateDate]) VALUES (3, 2, N'rdvvynul.wsw.jpg', N'', 0, CAST(0x0000A08F015A74E6 AS DateTime))
INSERT [dbo].[Photo] ([PhotoID], [UserID], [Url], [Desc], [IsMain], [CreateDate]) VALUES (4, 2, N'3k43zyzb.ekl.jpg', N'', 0, CAST(0x0000A08F015BD557 AS DateTime))
SET IDENTITY_INSERT [dbo].[Photo] OFF
/****** Object:  Table [dbo].[Invitation]    Script Date: 07/21/2012 18:59:24 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Invitation](
	[InvitationID] [int] IDENTITY(1,1) NOT NULL,
	[UserID] [int] NOT NULL,
	[PartyID] [int] NOT NULL,
	[IsConfirmed] [bit] NOT NULL,
	[SenderID] [int] NOT NULL,
	[SenderAccount] [nvarchar](25) NOT NULL,
	[InviteDate] [datetime] NOT NULL,
 CONSTRAINT [PK_Invitation] PRIMARY KEY CLUSTERED 
(
	[InvitationID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET IDENTITY_INSERT [dbo].[Invitation] ON
INSERT [dbo].[Invitation] ([InvitationID], [UserID], [PartyID], [IsConfirmed], [SenderID], [SenderAccount], [InviteDate]) VALUES (1, 7, 2, 1, 1, N'weiwei', CAST(0x0000A09300ACBDE3 AS DateTime))
INSERT [dbo].[Invitation] ([InvitationID], [UserID], [PartyID], [IsConfirmed], [SenderID], [SenderAccount], [InviteDate]) VALUES (2, 3, 2, 0, 1, N'weiwei', CAST(0x0000A09300ACBDE3 AS DateTime))
SET IDENTITY_INSERT [dbo].[Invitation] OFF
/****** Object:  Table [dbo].[Friend]    Script Date: 07/21/2012 18:59:24 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Friend](
	[FriendID] [int] IDENTITY(1,1) NOT NULL,
	[UserID] [int] NULL,
	[MyFriendID] [int] NOT NULL,
	[CreateDate] [datetime] NOT NULL,
	[IsConfirmed] [bit] NOT NULL,
 CONSTRAINT [PK_Friend] PRIMARY KEY CLUSTERED 
(
	[FriendID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET IDENTITY_INSERT [dbo].[Friend] ON
INSERT [dbo].[Friend] ([FriendID], [UserID], [MyFriendID], [CreateDate], [IsConfirmed]) VALUES (31, 1, 3, CAST(0x0000A092011D0232 AS DateTime), 1)
INSERT [dbo].[Friend] ([FriendID], [UserID], [MyFriendID], [CreateDate], [IsConfirmed]) VALUES (47, 3, 1, CAST(0x0000A0920122D3FA AS DateTime), 1)
INSERT [dbo].[Friend] ([FriendID], [UserID], [MyFriendID], [CreateDate], [IsConfirmed]) VALUES (48, 7, 1, CAST(0x0000A09300ABB225 AS DateTime), 1)
INSERT [dbo].[Friend] ([FriendID], [UserID], [MyFriendID], [CreateDate], [IsConfirmed]) VALUES (49, 1, 7, CAST(0x0000A09300AC65B2 AS DateTime), 1)
SET IDENTITY_INSERT [dbo].[Friend] OFF
/****** Object:  Table [dbo].[Supplier]    Script Date: 07/21/2012 18:59:24 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Supplier](
	[SID] [int] IDENTITY(1,1) NOT NULL,
	[MID] [int] NOT NULL,
	[Name] [nvarchar](30) NOT NULL,
	[Address] [ntext] NULL,
	[Phone] [varchar](20) NULL,
	[Order] [int] NOT NULL,
	[CreateDate] [datetime] NOT NULL,
 CONSTRAINT [PK_Supplier] PRIMARY KEY CLUSTERED 
(
	[SID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
SET IDENTITY_INSERT [dbo].[Supplier] ON
INSERT [dbo].[Supplier] ([SID], [MID], [Name], [Address], [Phone], [Order], [CreateDate]) VALUES (1, 11, N'tdfdf', N'dfdfdf', N'18217229563', 1, CAST(0x0000A0900107CFE0 AS DateTime))
INSERT [dbo].[Supplier] ([SID], [MID], [Name], [Address], [Phone], [Order], [CreateDate]) VALUES (2, 11, N'fff', N'ff', N'fff', 2, CAST(0x0000A0900107DD15 AS DateTime))
SET IDENTITY_INSERT [dbo].[Supplier] OFF
/****** Object:  Table [dbo].[Salutation]    Script Date: 07/21/2012 18:59:24 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Salutation](
	[SID] [int] IDENTITY(1,1) NOT NULL,
	[Type] [int] NOT NULL,
	[UserID] [int] NOT NULL,
	[GreetID] [int] NOT NULL,
	[Message] [nvarchar](20) NULL,
	[IsConfirm] [bit] NOT NULL,
	[SentDate] [datetime] NOT NULL,
 CONSTRAINT [PK_Salutation] PRIMARY KEY CLUSTERED 
(
	[SID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET IDENTITY_INSERT [dbo].[Salutation] ON
INSERT [dbo].[Salutation] ([SID], [Type], [UserID], [GreetID], [Message], [IsConfirm], [SentDate]) VALUES (3, 0, 1, 2, N'', 1, CAST(0x0000A08F0168B9BA AS DateTime))
INSERT [dbo].[Salutation] ([SID], [Type], [UserID], [GreetID], [Message], [IsConfirm], [SentDate]) VALUES (4, 0, 1, 3, N'', 1, CAST(0x0000A092010608F7 AS DateTime))
INSERT [dbo].[Salutation] ([SID], [Type], [UserID], [GreetID], [Message], [IsConfirm], [SentDate]) VALUES (5, 1, 7, 1, N'', 1, CAST(0x0000A09300ABA2EC AS DateTime))
SET IDENTITY_INSERT [dbo].[Salutation] OFF
/****** Object:  Table [dbo].[Message]    Script Date: 07/21/2012 18:59:24 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Message](
	[MessageID] [int] IDENTITY(1,1) NOT NULL,
	[UserID] [int] NOT NULL,
	[Title] [nvarchar](20) NOT NULL,
	[Content] [ntext] NULL,
	[IsRead] [bit] NOT NULL,
	[Source] [nvarchar](20) NULL,
	[CreateDate] [datetime] NOT NULL,
 CONSTRAINT [PK_Message] PRIMARY KEY CLUSTERED 
(
	[MessageID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
SET IDENTITY_INSERT [dbo].[Message] ON
INSERT [dbo].[Message] ([MessageID], [UserID], [Title], [Content], [IsRead], [Source], [CreateDate]) VALUES (16, 3, N'会员weiwei加您为好友', N'会员weiwei 加您为好友,快去看看吧', 0, N'好友', CAST(0x0000A0920105EE50 AS DateTime))
INSERT [dbo].[Message] ([MessageID], [UserID], [Title], [Content], [IsRead], [Source], [CreateDate]) VALUES (17, 3, N'weiwei的招呼', N'会员 weiwei 向您打招呼,快去看看吧', 0, N'打招呼', CAST(0x0000A09201060900 AS DateTime))
INSERT [dbo].[Message] ([MessageID], [UserID], [Title], [Content], [IsRead], [Source], [CreateDate]) VALUES (21, 3, N'招呼响应', N'', 0, N'打招呼', CAST(0x0000A09201063714 AS DateTime))
INSERT [dbo].[Message] ([MessageID], [UserID], [Title], [Content], [IsRead], [Source], [CreateDate]) VALUES (22, 3, N'招呼响应', N'', 0, N'打招呼', CAST(0x0000A092010637A8 AS DateTime))
INSERT [dbo].[Message] ([MessageID], [UserID], [Title], [Content], [IsRead], [Source], [CreateDate]) VALUES (23, 3, N'招呼响应', N'', 0, N'打招呼', CAST(0x0000A09201063840 AS DateTime))
INSERT [dbo].[Message] ([MessageID], [UserID], [Title], [Content], [IsRead], [Source], [CreateDate]) VALUES (24, 3, N'招呼响应', N'', 0, N'打招呼', CAST(0x0000A092010638E4 AS DateTime))
INSERT [dbo].[Message] ([MessageID], [UserID], [Title], [Content], [IsRead], [Source], [CreateDate]) VALUES (25, 3, N'会员weiwei加您为好友', N'会员weiwei 加您为好友,快去看看吧', 0, N'好友', CAST(0x0000A092010876F0 AS DateTime))
INSERT [dbo].[Message] ([MessageID], [UserID], [Title], [Content], [IsRead], [Source], [CreateDate]) VALUES (29, 3, N'会员weiwei加您为好友', N'会员weiwei 加您为好友,快去看看吧', 0, N'好友', CAST(0x0000A09201155F11 AS DateTime))
INSERT [dbo].[Message] ([MessageID], [UserID], [Title], [Content], [IsRead], [Source], [CreateDate]) VALUES (33, 3, N'会员weiwei加您为好友', N'会员weiwei 加您为好友,快去看看吧', 0, N'好友', CAST(0x0000A09201165411 AS DateTime))
INSERT [dbo].[Message] ([MessageID], [UserID], [Title], [Content], [IsRead], [Source], [CreateDate]) VALUES (37, 3, N'会员weiwei加您为好友', N'会员weiwei 加您为好友,快去看看吧', 0, N'好友', CAST(0x0000A09201184B39 AS DateTime))
INSERT [dbo].[Message] ([MessageID], [UserID], [Title], [Content], [IsRead], [Source], [CreateDate]) VALUES (41, 3, N'会员weiwei加您为好友', N'会员weiwei 加您为好友,快去看看吧', 0, N'好友', CAST(0x0000A092011D023C AS DateTime))
INSERT [dbo].[Message] ([MessageID], [UserID], [Title], [Content], [IsRead], [Source], [CreateDate]) VALUES (62, 7, N'好友请求通过', N'您的好友请求被通过！', 0, N'好友', CAST(0x0000A09300AC65B7 AS DateTime))
SET IDENTITY_INSERT [dbo].[Message] OFF
/****** Object:  Table [dbo].[Bonus]    Script Date: 07/21/2012 18:59:24 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Bonus](
	[BonusID] [int] IDENTITY(1,1) NOT NULL,
	[UserID] [int] NOT NULL,
	[Bonus] [decimal](10, 2) NULL,
	[UpdateDate] [datetime] NULL,
	[CreateDate] [datetime] NOT NULL,
 CONSTRAINT [PK_Bonus] PRIMARY KEY CLUSTERED 
(
	[BonusID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY],
 CONSTRAINT [UQ_Bonus_UserID] UNIQUE NONCLUSTERED 
(
	[UserID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET IDENTITY_INSERT [dbo].[Bonus] ON
INSERT [dbo].[Bonus] ([BonusID], [UserID], [Bonus], [UpdateDate], [CreateDate]) VALUES (1, 1, CAST(-3.00 AS Decimal(10, 2)), CAST(0x0000A09300FAB831 AS DateTime), CAST(0x0000A08C0162F93D AS DateTime))
INSERT [dbo].[Bonus] ([BonusID], [UserID], [Bonus], [UpdateDate], [CreateDate]) VALUES (2, 2, CAST(64.00 AS Decimal(10, 2)), CAST(0x0000A093011DB738 AS DateTime), CAST(0x0000A08C01649FE2 AS DateTime))
INSERT [dbo].[Bonus] ([BonusID], [UserID], [Bonus], [UpdateDate], [CreateDate]) VALUES (3, 3, CAST(49.00 AS Decimal(10, 2)), CAST(0x0000A092010638F3 AS DateTime), CAST(0x0000A08D01158404 AS DateTime))
INSERT [dbo].[Bonus] ([BonusID], [UserID], [Bonus], [UpdateDate], [CreateDate]) VALUES (4, 4, CAST(50.00 AS Decimal(10, 2)), CAST(0x0000A08F01215296 AS DateTime), CAST(0x0000A08F01215296 AS DateTime))
INSERT [dbo].[Bonus] ([BonusID], [UserID], [Bonus], [UpdateDate], [CreateDate]) VALUES (5, 5, CAST(76.00 AS Decimal(10, 2)), CAST(0x0000A09200D536A5 AS DateTime), CAST(0x0000A09200D536A5 AS DateTime))
INSERT [dbo].[Bonus] ([BonusID], [UserID], [Bonus], [UpdateDate], [CreateDate]) VALUES (6, 6, CAST(50.00 AS Decimal(10, 2)), CAST(0x0000A09300A69117 AS DateTime), CAST(0x0000A09300A69117 AS DateTime))
INSERT [dbo].[Bonus] ([BonusID], [UserID], [Bonus], [UpdateDate], [CreateDate]) VALUES (7, 7, CAST(79.00 AS Decimal(10, 2)), CAST(0x0000A09300AB74E3 AS DateTime), CAST(0x0000A09300A8041D AS DateTime))
INSERT [dbo].[Bonus] ([BonusID], [UserID], [Bonus], [UpdateDate], [CreateDate]) VALUES (8, 8, CAST(50.00 AS Decimal(10, 2)), CAST(0x0000A09400BAB816 AS DateTime), CAST(0x0000A09400BAB816 AS DateTime))
INSERT [dbo].[Bonus] ([BonusID], [UserID], [Bonus], [UpdateDate], [CreateDate]) VALUES (9, 9, CAST(50.00 AS Decimal(10, 2)), CAST(0x0000A09400DF55E5 AS DateTime), CAST(0x0000A09400DF55E5 AS DateTime))
INSERT [dbo].[Bonus] ([BonusID], [UserID], [Bonus], [UpdateDate], [CreateDate]) VALUES (10, 10, CAST(50.00 AS Decimal(10, 2)), CAST(0x0000A09500A0FA0F AS DateTime), CAST(0x0000A09500A0FA0F AS DateTime))
SET IDENTITY_INSERT [dbo].[Bonus] OFF
/****** Object:  ForeignKey [FK_Modality_PartyType]    Script Date: 07/21/2012 18:59:24 ******/
ALTER TABLE [dbo].[Modality]  WITH CHECK ADD  CONSTRAINT [FK_Modality_PartyType] FOREIGN KEY([PID])
REFERENCES [dbo].[PartyType] ([PID])
GO
ALTER TABLE [dbo].[Modality] CHECK CONSTRAINT [FK_Modality_PartyType]
GO
/****** Object:  ForeignKey [FK_User_Account]    Script Date: 07/21/2012 18:59:24 ******/
ALTER TABLE [dbo].[User]  WITH CHECK ADD  CONSTRAINT [FK_User_Account] FOREIGN KEY([AccountID])
REFERENCES [dbo].[Account] ([AccountID])
GO
ALTER TABLE [dbo].[User] CHECK CONSTRAINT [FK_User_Account]
GO
/****** Object:  ForeignKey [FK_UserView_User]    Script Date: 07/21/2012 18:59:24 ******/
ALTER TABLE [dbo].[UserView]  WITH CHECK ADD  CONSTRAINT [FK_UserView_User] FOREIGN KEY([UserID])
REFERENCES [dbo].[User] ([UserID])
GO
ALTER TABLE [dbo].[UserView] CHECK CONSTRAINT [FK_UserView_User]
GO
/****** Object:  ForeignKey [FK_UserPartyAssociation_Party]    Script Date: 07/21/2012 18:59:24 ******/
ALTER TABLE [dbo].[UserPartyAssociation]  WITH CHECK ADD  CONSTRAINT [FK_UserPartyAssociation_Party] FOREIGN KEY([PartyID])
REFERENCES [dbo].[Party] ([PartyID])
GO
ALTER TABLE [dbo].[UserPartyAssociation] CHECK CONSTRAINT [FK_UserPartyAssociation_Party]
GO
/****** Object:  ForeignKey [FK_UserPartyAssociation_User]    Script Date: 07/21/2012 18:59:24 ******/
ALTER TABLE [dbo].[UserPartyAssociation]  WITH CHECK ADD  CONSTRAINT [FK_UserPartyAssociation_User] FOREIGN KEY([UserID])
REFERENCES [dbo].[User] ([UserID])
GO
ALTER TABLE [dbo].[UserPartyAssociation] CHECK CONSTRAINT [FK_UserPartyAssociation_User]
GO
/****** Object:  ForeignKey [FK_Photo_User]    Script Date: 07/21/2012 18:59:24 ******/
ALTER TABLE [dbo].[Photo]  WITH CHECK ADD  CONSTRAINT [FK_Photo_User] FOREIGN KEY([UserID])
REFERENCES [dbo].[User] ([UserID])
GO
ALTER TABLE [dbo].[Photo] CHECK CONSTRAINT [FK_Photo_User]
GO
/****** Object:  ForeignKey [FK_Invitation_User]    Script Date: 07/21/2012 18:59:24 ******/
ALTER TABLE [dbo].[Invitation]  WITH CHECK ADD  CONSTRAINT [FK_Invitation_User] FOREIGN KEY([UserID])
REFERENCES [dbo].[User] ([UserID])
GO
ALTER TABLE [dbo].[Invitation] CHECK CONSTRAINT [FK_Invitation_User]
GO
/****** Object:  ForeignKey [FK_Friend_User]    Script Date: 07/21/2012 18:59:24 ******/
ALTER TABLE [dbo].[Friend]  WITH CHECK ADD  CONSTRAINT [FK_Friend_User] FOREIGN KEY([UserID])
REFERENCES [dbo].[User] ([UserID])
GO
ALTER TABLE [dbo].[Friend] CHECK CONSTRAINT [FK_Friend_User]
GO
/****** Object:  ForeignKey [FK_Supplier_Modality]    Script Date: 07/21/2012 18:59:24 ******/
ALTER TABLE [dbo].[Supplier]  WITH CHECK ADD  CONSTRAINT [FK_Supplier_Modality] FOREIGN KEY([MID])
REFERENCES [dbo].[Modality] ([MID])
GO
ALTER TABLE [dbo].[Supplier] CHECK CONSTRAINT [FK_Supplier_Modality]
GO
/****** Object:  ForeignKey [FK_Salutation_User]    Script Date: 07/21/2012 18:59:24 ******/
ALTER TABLE [dbo].[Salutation]  WITH CHECK ADD  CONSTRAINT [FK_Salutation_User] FOREIGN KEY([UserID])
REFERENCES [dbo].[User] ([UserID])
GO
ALTER TABLE [dbo].[Salutation] CHECK CONSTRAINT [FK_Salutation_User]
GO
/****** Object:  ForeignKey [FK_Message_User]    Script Date: 07/21/2012 18:59:24 ******/
ALTER TABLE [dbo].[Message]  WITH CHECK ADD  CONSTRAINT [FK_Message_User] FOREIGN KEY([UserID])
REFERENCES [dbo].[User] ([UserID])
GO
ALTER TABLE [dbo].[Message] CHECK CONSTRAINT [FK_Message_User]
GO
/****** Object:  ForeignKey [FK_Bonus_User]    Script Date: 07/21/2012 18:59:24 ******/
ALTER TABLE [dbo].[Bonus]  WITH CHECK ADD  CONSTRAINT [FK_Bonus_User] FOREIGN KEY([UserID])
REFERENCES [dbo].[User] ([UserID])
GO
ALTER TABLE [dbo].[Bonus] CHECK CONSTRAINT [FK_Bonus_User]
GO
